CAST AIP Extensions
Page tree

Versions Compared

Old Version 1

changes.mady.by.user James Hurrell

Saved on

compared with

New Version Current

changes.mady.by.user James Hurrell

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Redirect
visiblefalse
locationTECHNOS:SQL Analyzer - errors and warnings


Message IDMessage Type

Logged during

ImpactRemediationAction
SQL-001WarningAnalysisOnly for .src files, when your src file is not specified in uaxdirectory file. The object defined in the src file will be added on DEFAULT schema.

Open the uaxdirectory file and add you're object in the good shema.

Please refer to CAST DB Extractor official documentation for more details.

if the warning is still raised, contact CAST Technical Support
SQL-002WarningAnalysisParsing issue, you could miss objects contact CAST Technical Support and provide full warning message and file
SQL-003WarningAnalysisYou will miss links contact CAST Technical Support and provide full warning message and file
SQL-004WarningAnalysisAnalysis issue detected in a file. You will miss links/properties for the object which is declared betweens lines reported in the warning message. contact CAST Technical Support and provide the full warning message and the statement you have between lines reported in your warning message
SQL-005WarningAnalysisNon supported RENAME TABLE between different schemes/databases  
SQL-006WarningAnalysisViews will not be resolved contact CAST Technical Support
SQL-007WarningApplication levelImpact on cartography, synonyms are duplicated.

Create an Update CAST Knowledge Base job for the following SQL query:

Code Block
languagesql
insert into CI_NO_OBJECTS (OBJECT_ID, ERROR_ID)
select IdKey, 0 from Keys 
 where 
 ObjTyp in ( 1101042, 1101043, 1101044, 1101045, 1101046) -- specific synonyms

 

Please refer to Update CAST Knowledge Base official documentation for more details.

if the synonyms are still duplicated, contact CAST Technical Support

SQL-008WarningApplication levelAvoid Artifacts with High Depth of Code (7768) will miss from AED/CED contact CAST Technical Support
SQL-009WarningApplication levelAvoid Artifacts with lines longer than X characters (7784) will miss from AED/CED contact CAST Technical Support
SQL-010WarningApplication levelAvoid Artifacts with SQL statement including subqueries (7808) will miss from AED/CED contact CAST Technical Support
SQL-011WarningApplication levelAvoid Artifacts with High Depth of Nested Subqueries (7130) will miss from AED/CED contact CAST Technical Support
SQL-012WarningApplication levelPrefer UNION ALL to UNION (7436) will miss from AED/CED contact CAST Technical Support
SQL-013WarningApplication levelImpact on cartography, links could not be moved from ynonyms to aliased objects.

Create an Update CAST Knowledge Base job for the following SQL query:

Code Block
languagesql
insert into CI_LINKS (CALLER_ID, CALLED_ID, LINK_TYPE, ERROR_ID)
select distinct links.idClr, objects.IdKey, links.TypNam, 0
 from 
 (select link.*, t.TypNam from 
 Acc link, Keys syn, Keys Obj, Typ t
 where Syn.IdKey = link.IdCle
 and Syn.ObjTyp in ( 1101042, 1101043, 1101044, 1101045, 1101046)
 and Obj.IdKey = link.IdClr
 and t.IdTyp in (
 select IdTyp from TypAttr where AttrNam = 'ACCTYPLO' and IntVal = link.AccTypLo
 )
 and t.IdTyp in (
 select IdTyp from TypAttr where AttrNam = 'ACCTYPHI' and IntVal = link.AccTypHi
 )
 and exists(select 1 from AccBook where IdAcc = link.IdAcc)) links,
 ( select Obj.IdKey, Syn.IdKey SynKey
 from Keys Syn, Keys Obj, Acc link
 where Syn.IdKey = link.IdClr
 and Syn.ObjTyp in ( 1101042, 1101043, 1101044, 1101045, 1101046)
 and Obj.IdKey = link.IdCle
 and link.AccTypLo = 65536) objects
 where links.IdCle = objects.SynKey 
 and objects.IdKey <> links.IdCle
 and exists(select 1
 from 
 (select link.* from 
 Acc link, Keys syn, Keys Obj
 where Syn.IdKey = link.IdCle
 and Syn.ObjTyp in ( 1101042, 1101043, 1101044, 1101045, 1101046)
 and Obj.IdKey = link.IdClr
 and exists(select 1 from AccBook where IdAcc = link.IdAcc)) links,
 ( select Obj.IdKey, Syn.IdKey SynKey
 from Keys Syn, Keys Obj, Acc link
 where Syn.IdKey = link.IdClr
 and Syn.ObjTyp in ( 1101042, 1101043, 1101044, 1101045, 1101046)
 and Obj.IdKey = link.IdCle
 and link.AccTypLo = 65536) objects
 where links.IdCle = objects.SynKey 
 and objects.IdKey <> links.IdCle
 )

Please refer to Update CAST Knowledge Base official documentation for more details.

if links are still not moved, contact CAST Technical Support

...