CAST AIP Technologies
Page tree
Skip to end of metadata
Go to start of metadata
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:

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:

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

 SQL-014 Warning AnalysisSelected files are not SQL and we can't analyze them. E.g.: you have select CAST extractions that are not SQL, e.g.: Forms extractions.Remove your SQL analysis unit. If the warning is still raised, contact CAST Technical Support and provide full warning message and analysis log.
 SQL-015WarningApplication levelAvoid using SQL queries inside loops (7424) will miss from AED/CED
Contact CAST Technical Support
  • No labels