After completing UMT. I am checking the integrity check. While converting .UNV universe to .UNX using IDT in 4.1 SP1.
While checking the check integrity. I am getting huge errors.
Connection are ok.
Pelase guide me…
Severity Rule Name Status Object
OK Check Parameter OK
OK Check Connection OK
OK Check Dependencies OK
OK Check Calculated Column OK
OK Check Business Object Name OK
ERROR Check for Undefined Cardinality The cardinality of the join dbo.CustMaster.CustID=dbo.Subset.CustID in data foundation Heat is undetermined. dbo.CustMaster.CustID=dbo.Subset.CustID
ERROR Check for Undefined Cardinality The cardinality of the join dbo.Policy1.PolicyNo=dbo.Subset.PolicyNo in data foundation Heat is undetermined. dbo.Policy1.PolicyNo=dbo.Subset.PolicyNo
ERROR Check for Undefined Cardinality The cardinality of the join dbo.Subset.AgentID=dbo.Profile.CustID in data foundation Heat is undetermined. dbo.Subset.AgentID=dbo.Profile.CustID
ERROR Check for Undefined Cardinality The cardinality of the join dbo.CallLog_Surround.CallID=dbo.CallLog.CallID in data foundation Heat is undetermined. dbo.CallLog_Surround.CallID=dbo.CallLog.CallID
ERROR Check for Undefined Cardinality The cardinality of the join Journal Entry time".CallID=dbo.CallLog.CallID in data foundation Heat is undetermined." Journal Entry time".CallID=dbo.CallLog.CallID"
ERROR Check for Undefined Cardinality The cardinality of the join dbo.Detail_S2T.InteractionID=dbo.CallLog.InteractionID in data foundation Heat is undetermined. dbo.Detail_S2T.InteractionID=dbo.CallLog.InteractionID
ERROR Check for Undefined Cardinality The cardinality of the join dbo.Detail_S2TREINSTATEMENT.InteractionID=dbo.CallLog.InteractionID in data foundation Heat is undetermined. dbo.Detail_S2TREINSTATEMENT.InteractionID=dbo.CallLog.InteractionID
ERROR Check for Undefined Cardinality The cardinality of the join Journal Entry time".CallID="Assignment Min time".CallID in data foundation Heat is undetermined." Journal Entry time".CallID="Assignment Min time".CallID"
ERROR Check for Undefined Cardinality The cardinality of the join dbo.Journal_Surround.InteractionID=dbo.CallLog.InteractionID in data foundation Heat is undetermined. dbo.Journal_Surround.InteractionID=dbo.CallLog.InteractionID
ERROR Check for Undefined Cardinality The cardinality of the join dbo.IRDA_Register_Complaint.InteractionID=dbo.CallLog_Surround.InteractionID in data foundation Heat is undetermined. dbo.IRDA_Register_Complaint.InteractionID=dbo.CallLog_Surround.InteractionID
ERROR Check for Undefined Cardinality The cardinality of the join dbo_Policy_Csrg.PolicyNo=dbo.Subset.PolicyNo in data foundation Heat is undetermined. dbo_Policy_Csrg.PolicyNo=dbo.Subset.PolicyNo
ERROR Check for Undefined Cardinality The cardinality of the join dbo.fresh_email_calls.CALLID=dbo.CallLog.CallID in data foundation Heat is undetermined. dbo.fresh_email_calls.CALLID=dbo.CallLog.CallID
ERROR Check for Undefined Cardinality The cardinality of the join dbo.CallLog.CallID=dbo.ReOpenedDetails.InteractionID in data foundation Heat is undetermined. dbo.CallLog.CallID=dbo.ReOpenedDetails.InteractionID
ERROR Check for Undefined Cardinality The cardinality of the join dbo.CallLog_Surround.InteractionID=dbo.Subset_Surround.InteractionID in data foundation Heat is undetermined. dbo.CallLog_Surround.InteractionID=dbo.Subset_Surround.InteractionID
ERROR Check for Undefined Cardinality The cardinality of the join dbo.Subset_Surround.CustID=dbo.ClientAlert_Surround.CustID in data foundation Heat is undetermined. dbo.Subset_Surround.CustID=dbo.ClientAlert_Surround.CustID
ERROR Check for Undefined Cardinality The cardinality of the join dbo.Subset_Surround.CustID=UPSELL_DATA.dbo.UpsellBIUData.CUST_CLIENT_NUM in data foundation Heat is undetermined. dbo.Subset_Surround.CustID=UPSELL_DATA.dbo.UpsellBIUData.CUST_CLIENT_NUM
WARNING Check for Isolated Table Table Detail_Retention is not joined to any other table. Detail_Retention
WARNING Check for Isolated Table Table GroupMemberUpdate is not joined to any other table. GroupMemberUpdate
WARNING Check for Isolated Table Table LogLead_Surround is not joined to any other table. LogLead_Surround
WARNING Check for Isolated Table Table UPSELL_PITCH_HISTORY is not joined to any other table. UPSELL_PITCH_HISTORY
WARNING Check for Isolated Table Table Role_Surround is not joined to any other table. Role_Surround
WARNING Check Table Primary Key Table Tracker is missing a primary key. Tracker
WARNING Check Table Primary Key Table Asgnmnt is missing a primary key. Asgnmnt
WARNING Check Table Primary Key Table CallLog is missing a primary key. CallLog
WARNING Check Table Primary Key Table Detail is missing a primary key. Detail
WARNING Check Table Primary Key Table Journal is missing a primary key. Journal
WARNING Check Table Primary Key Table Subset is missing a primary key. Subset
WARNING Check Table Primary Key Table Customer is missing a primary key. Customer
WARNING Check Table Primary Key Table Policy is missing a primary key. Policy
WARNING Check Table Primary Key Table Assignee is missing a primary key. Assignee
WARNING Check Table Primary Key Table AreaMaster is missing a primary key. AreaMaster
WARNING Check Table Primary Key Table City is missing a primary key. City
WARNING Check Table Primary Key Table LocationMaster is missing a primary key. LocationMaster
WARNING Check Table Primary Key Table RoleMaster is missing a primary key. RoleMaster
WARNING Check Table Primary Key Table SubCallType is missing a primary key. SubCallType
WARNING Check Table Primary Key Table HEATActv is missing a primary key. HEATActv
WARNING Check Table Primary Key Table Policy1 is missing a primary key. Policy1
WARNING Check Table Primary Key Table CustMaster is missing a primary key. CustMaster
WARNING Check Table Primary Key Table Profile is missing a primary key. Profile
WARNING Check Table Primary Key Table Detail_Retention is missing a primary key. Detail_Retention
WARNING Check Table Primary Key Table CallLog_Surround is missing a primary key. CallLog_Surround
WARNING Check Table Primary Key Table Detail_S2TREINSTATEMENT is missing a primary key. Detail_S2TREINSTATEMENT
WARNING Check Table Primary Key Table Detail_S2T is missing a primary key. Detail_S2T
WARNING Check Table Primary Key Table Asgnmnt_Decisions is missing a primary key. Asgnmnt_Decisions
WARNING Check Table Primary Key Table Journal_Surround is missing a primary key. Journal_Surround
WARNING Check Table Primary Key Table GroupMemberUpdate is missing a primary key. GroupMemberUpdate
WARNING Check Table Primary Key Table IRDA_Register_Complaint is missing a primary key. IRDA_Register_Complaint
WARNING Check Table Primary Key Table fresh_email_calls is missing a primary key. fresh_email_calls
WARNING Check Table Primary Key Table ReOpenedDetails is missing a primary key. ReOpenedDetails
WARNING Check Table Primary Key Table Subset_Surround is missing a primary key. Subset_Surround
WARNING Check Table Primary Key Table ClientAlert_Surround is missing a primary key. ClientAlert_Surround
The errors that you are getting are not critical errors. I generally will not check the cardinality of a join via the integrity check (for a wide variety of reasons) and the check for database keys is also not required. I suggest that you remove those options from the integrity check and see what else comes up.
Just to add to what Dave has said, isolated tables may or may not be an issue - often they are the sources of multiple aliases. There are also people who put all tables in one area upon import and only ever use aliases in the schema.
Thanks Guru’s for all.I am following your instructions going forward…
This is my procedure which i am following during the migration from BOXIR3 to BI4.1
steps at BOXIR3.1
Initially refresh structure and export to repository.
Taking the .biar file with universe & reports.
3)converting DEski reports to webi using RCT no use mostly are partially converted only.
prob. most of deski reports are having the Macros. and Input parameters.
for RCT we will discuss later… its huge …
steps at BI4.1 SP2
1)Through UMT i am taking the Incremental Upgrade via biar to live method.
i) publish to repository.
2) Once it is done checking Integrity is not mandatory hope so…
3) Converting .UNV to .UNX through IDT.
4) checking the webi report got success or some thing error facing.
please let me know if am missing any thing here while migrating the reports.
please guide on what basis should i follow to get success in migration easily not too much of hurdles…
connection,universe,reports
Thanx alot nick!!! i will post the new integrigy log.
I am facing the new issue.
I have migrated the reports which is succesfull done.
while i am running manually in any client machine it is running getting the output matching no records excatly! with XIR3 report output both are matched.
1)Issue.
Here while i am scheduling through CMC or open through BI launch pad it is throwing error that…
error… Database error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. (IES 10901)
Issue.
while some reports data is coming less no of records. report is succesfully refreshed bt no. of records are not mathced.
As per I am Understasnding becoz my BI4.1 CMSDB is not sync with exactly with BOXIR3 CMSDB.
Please correct me if i am not correct means.
[b]Database error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. (IES 10901)
After struglling 2-3 days finally got the solution.
Sol. Both the 32bit & 64 bit ODBC drivers should be in sync i.e.,[/b]
after that my report is got success through CMC as well as in BI launch pad also too.
[quote:e951266955=“rvrsarma.1982”][b]Database error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. (IES 10901)
After struglling 2-3 days finally got the solution.
Sol. Both the 32bit & 64 bit ODBC drivers should be in sync i.e.,[/b]
after that my report is got success through CMC as well as in BI launch pad also too.
thanks alot Nick & Mark
I am post after refesh structure seems so many errors were reduced.
log generated.
“Severity”;“Rule Name”;“Status”;“Object”;
“OK”;“Check Parameter”;“OK”;“”;
“OK”;“Check Dependencies”;“OK”;“”;
“OK”;“Check Context”;“OK”;“”;
“OK”;“Check Loops”;“OK”;“”;
“OK”;“Check Business Object Name “;“OK”;””;
“OK”;“Check Query”;“OK”;“”;
“ERROR”;“Check for Undefined Cardinality “;“The cardinality of the join “Claims_PCS”.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CLAIMKEY in data foundation Caps_Claims is undetermined.”;”“Claims_PCS”.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CLAIMKEY”;
“ERROR”;“Check for Undefined Cardinality “;“The cardinality of the join HOSPITAL_ID.CLAIMKEY=CLAIMS.LF$APP_CLAIM.CLAIMKEY in data foundation Caps_Claims is undetermined.”;“HOSPITAL_ID.CLAIMKEY=CLAIMS.LF$APP_CLAIM.CLAIMKEY”;
“ERROR”;“Check for Undefined Cardinality “;“The cardinality of the join MAX_FINAL_DECISION_DATE.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID in data foundation Caps_Claims is undetermined.”;“MAX_FINAL_DECISION_DATE.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID”;
“ERROR”;“Check for Undefined Cardinality “;“The cardinality of the join MAX_DECISION_DATE_HCH.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID in data foundation Caps_Claims is undetermined.”;“MAX_DECISION_DATE_HCH.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID”;
“OK”;“Check Alias Table”;“OK”;””;
“WARNING”;“Check Table Primary Key”;“Table LF$APP_VAM_TREATMENT is missing a primary key.”;“LF$APP_VAM_TREATMENT”;
“WARNING”;“Check Table Primary Key”;“Table LF$APP_PHYSICIAN is missing a primary key.”;“LF$APP_PHYSICIAN”;
“WARNING”;“Check Table Primary Key”;“Table LF$APP_ENDORSEMENT is missing a primary key.”;“LF$APP_ENDORSEMENT”;
“WARNING”;“Check Table Primary Key”;“Table LF$APP_DOCUMENT_MAPPER is missing a primary key.”;“LF$APP_DOCUMENT_MAPPER”;
“WARNING”;“Check Table Primary Key”;“Table LF$APP_DOCUMENT_REFRENCE is missing a primary key.”;“LF$APP_DOCUMENT_REFRENCE”;
“WARNING”;“Check Table Primary Key”;“Table LF$APP_DOCUMENT_MASTER is missing a primary key.”;“LF$APP_DOCUMENT_MASTER”;
“WARNING”;“Check Table Primary Key”;“Table LF$APP_SMS_TEMPLATES is missing a primary key.”;“LF$APP_SMS_TEMPLATES”;
“WARNING”;“Check Table Primary Key”;“Table LF$APP_COMM_TRIGGERS is missing a primary key.”;“LF$APP_COMM_TRIGGERS”;
“WARNING”;“Check Table Primary Key”;“Table LF$APP_GRIEVANCE is missing a primary key.”;“LF$APP_GRIEVANCE”;
“WARNING”;“Check Table Primary Key”;“Table LF$APP_HINDSIGHTING is missing a primary key.”;“LF$APP_HINDSIGHTING”;
“WARNING”;“Check for Isolated Table”;“Table CLAIMS.LF$APP_COMM_SMS is not joined to any other table.”;“CLAIMS.LF$APP_COMM_SMS”;
“WARNING”;“Check for Isolated Table”;“Table CLAIMS.LF$APP_COMM_LETTERS is not joined to any other table.”;“CLAIMS.LF$APP_COMM_LETTERS”;
“WARNING”;“Check for Isolated Table”;“Table Claims_Work_Queue is not joined to any other table.”;“Claims_Work_Queue”;
“WARNING”;“Check for Isolated Table”;“Table Communication_Claims is not joined to any other table.”;“Communication_Claims”;
“WARNING”;“Check for Isolated Table”;“Table Cost_MR is not joined to any other table.”;“Cost_MR”;
“WARNING”;“Check for Isolated Table”;“Table Hospital is not joined to any other table.”;“Hospital”;
“WARNING”;“Check for Isolated Table”;“Table Work_Queue is not joined to any other table.”;“Work_Queue”;
“WARNING”;“Check for Isolated Table”;“Table LF$APP_CLAIM_TAXDETAILS is not joined to any other table.”;“LF$APP_CLAIM_TAXDETAILS”;
“WARNING”;“Check for Isolated Table”;“Table DECISION_OVERRIDE is not joined to any other table.”;“DECISION_OVERRIDE”;
“OK”;“Check Connection”;“OK”;””;
“OK”;“Check Calculated Column”;“OK”;””;
“ERROR”;“Check Table Structure”;“Table LF$APP_ACTIVITY referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_ACTIVITY”;
“ERROR”;“Check Table Structure”;“Table LF$APP_ADDRESS referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_ADDRESS”;
“ERROR”;“Check Table Structure”;“Table LF$APP_CLAIM referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_CLAIM”;
“ERROR”;“Check Table Structure”;“Table LF$APP_VAM_PREAUTH referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_VAM_PREAUTH”;
“ERROR”;“Check Table Structure”;“Table LF$APP_KEYEDVALUE referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_KEYEDVALUE”;
“ERROR”;“Check Table Structure”;“Table LF$APP_ATTACHMENT referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_ATTACHMENT”;
“ERROR”;“Check Table Structure”;“Table LF$APP_RELATION referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_RELATION”;
“ERROR”;“Check Table Structure”;“Table LF$APP_POLICY referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_POLICY”;
“ERROR”;“Check Table Structure”;“Table LF$APP_PARTY referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_PARTY”;
“ERROR”;“Check Table Structure”;“Table LF$APP_COVOPTION referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_COVOPTION”;
“ERROR”;“Check Table Structure”;“Table LF$APP_EVENTDETAILS referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_EVENTDETAILS”;
“ERROR”;“Check Table Structure”;“Table LF$APP_CLAIMINFORMATION referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_CLAIMINFORMATION”;
“ERROR”;“Check Table Structure”;“Table LF$APP_COMMUNICATION referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_COMMUNICATION”;
“ERROR”;“Check Table Structure”;“Table LF$APP_CUSTOMERCALLING referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_CUSTOMERCALLING”;
“ERROR”;“Check Table Structure”;“Table LF$APP_FINALDECISION referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_FINALDECISION”;
“ERROR”;“Check Table Structure”;“Table LF$APP_FRAUDDETAILS referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_FRAUDDETAILS”;
“ERROR”;“Check Table Structure”;“Table LF$APP_PAYMENTDETAILS referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_PAYMENTDETAILS”;
“ERROR”;“Check Table Structure”;“Table LF$APP_REFFERALS referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_REFFERALS”;
“ERROR”;“Check Table Structure”;“Table LF$APP_VAM_DIAGNOSIS referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_VAM_DIAGNOSIS”;
“ERROR”;“Check Table Structure”;“Table LF$APP_VAM_NETWORKASSESSMENT referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_VAM_NETWORKASSESSMENT”;
“ERROR”;“Check Table Structure”;“Table LF$APP_VAM_PASTILLNESS referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_VAM_PASTILLNESS”;
“ERROR”;“Check Table Structure”;“Table LF$APP_INVESTIGATION referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_INVESTIGATION”;
“ERROR”;“Check Table Structure”;“Table LF$APP_REQUIREMENTINFO referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_REQUIREMENTINFO”;
“ERROR”;“Check Table Structure”;“Table LF$APP_HOLDING referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_HOLDING”;
“ERROR”;“Check Table Structure”;“Table LF$APP_VAM_PREAUTHBENDETAIL referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_VAM_PREAUTHBENDETAIL”;
“ERROR”;“Check Table Structure”;“Table LF$APP_VAM_TREATMENT referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_VAM_TREATMENT”;
“ERROR”;“Check Table Structure”;“Table LF$APP_SUBEVENTDETAILS referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_SUBEVENTDETAILS”;
“ERROR”;“Check Table Structure”;“Table LF$APP_PERSON referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_PERSON”;
“ERROR”;“Check Table Structure”;“Table LF$APP_PHONE referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_PHONE”;
“ERROR”;“Check Table Structure”;“Table LF$APP_PHYSICIAN referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_PHYSICIAN”;
“ERROR”;“Check Table Structure”;“Table LF$APP_ORGANIZATION referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_ORGANIZATION”;
“ERROR”;“Check Table Structure”;“Table LF$APP_CLIENT referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_CLIENT”;
“ERROR”;“Check Table Structure”;“Table LF$APP_EMAILADDRESS referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_EMAILADDRESS”;
“ERROR”;“Check Table Structure”;“Table LF$APP_EMPLOYMENT referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_EMPLOYMENT”;
“ERROR”;“Check Table Structure”;“Table LF$APP_EDUCATION referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_EDUCATION”;
“ERROR”;“Check Table Structure”;“Table LF$APP_RISK referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_RISK”;
“ERROR”;“Check Table Structure”;“Table LF$APP_ENDORSEMENT referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_ENDORSEMENT”;
“ERROR”;“Check Table Structure”;“Table LF$APP_DISABILITYHEALTH referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_DISABILITYHEALTH”;
“ERROR”;“Check Table Structure”;“Table LF$APP_RIDER referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_RIDER”;
“ERROR”;“Check Table Structure”;“Table LF$APP_DOCUMENT_MAPPER referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_DOCUMENT_MAPPER”;
“ERROR”;“Check Table Structure”;“Table LF$APP_DOCUMENT_REFRENCE referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_DOCUMENT_REFRENCE”;
“ERROR”;“Check Table Structure”;“Table LF$APP_DOCUMENT_MASTER referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_DOCUMENT_MASTER”;
“ERROR”;“Check Table Structure”;“Table LF$APP_SMS_TEMPLATES referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_SMS_TEMPLATES”;
“ERROR”;“Check Table Structure”;“Table LF$APP_COMM_TRIGGERS referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_COMM_TRIGGERS”;
“ERROR”;“Check Table Structure”;“Table LF$APP_GRIEVANCE referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_GRIEVANCE”;
“ERROR”;“Check Table Structure”;“Table LF$APP_HINDSIGHTING referenced in data foundation Caps_Claims does not exist in the database.”;“LF$APP_HINDSIGHTING”;
“OK”;“Check Business Filter”;“OK”;“”;
“OK”;“Check Join”;“OK”;“”;
“OK”;“Check Business Object Mapping”;“OK”;“”;
“ERROR”;“Check Derived Table”;“The SQL expression for the derived table LADETAILS in the data foundation Caps_Claims is invalid.”;“LADETAILS”;
“ERROR”;“Check Derived Table”;“The SQL expression for the derived table DECISION_OVERRIDE in the data foundation Caps_Claims is invalid.”;“DECISION_OVERRIDE”;
“OK”;“Check List of Values”;“OK”;“”;
“ERROR”;“Check Business Object Expression”;“Business object ‘Claims Lf$app Keyedvalue2\Keyvalue’ returns an incorrect data type.”;“Keyvalue”;
“ERROR”;“Check Business Object Expression”;“Business object ‘Claims Lf$app Keyedvalue\Keyvalue’ returns an incorrect data type.”;“Keyvalue”;
“ERROR”;“Check Business Object Expression”;“Business object ‘Claims Lf$app Keyedvalue3\Keyvalue’ returns an incorrect data type.”;“Keyvalue”;
“ERROR”;“Check Business Object Expression”;“Business object ‘Claims Lf$app Claiminformation\Versionnumber’ returns an incorrect data type.”;“Versionnumber”;
“ERROR”;“Check Business Object Expression”;“Business object ‘Claims Lf$app Keyedvalue32\Keyvalue’ returns an incorrect data type.”;“Keyvalue”;
“ERROR”;“Check Business Object Expression”;“Business object ‘Party Relation\Keyvalue’ returns an incorrect data type.”;“Keyvalue”;
“ERROR”;“Check Business Object Expression”;“Business object ‘Hospital Id\Hospital Id’ returns an incorrect data type.”;“Hospital Id”;
“ERROR”;“Check Business Object Expression”;“Business object ‘Ladetails\Lastatus’ returns an incorrect data type.”;“Lastatus”;
“ERROR”;“Check Business Object Expression”;“Failed to execute the expression for business object ‘Ladetails\System Recommended Amt’. Check the object properties.”;“System Recommended Amt”;
“ERROR”;“Check Business Object Expression”;“Failed to execute the expression for business object ‘Decision Override\Polnumber’. Check the object properties.”;“Polnumber”;
“ERROR”;“Check Business Object Expression”;“Failed to execute the expression for business object ‘Decision Override\Productcode’. Check the object properties.”;“Productcode”;
“ERROR”;“Check Business Object Expression”;“Failed to execute the expression for business object ‘Decision Override\Canonicalid’. Check the object properties.”;“Canonicalid”;
“ERROR”;“Check Business Object Expression”;“Failed to execute the expression for business object ‘Decision Override\Claimnumber’. Check the object properties.”;“Claimnumber”;
“ERROR”;“Check Business Object Expression”;“Failed to execute the expression for business object ‘Decision Override\Claimtype’. Check the object properties.”;“Claimtype”;
“ERROR”;“Check Business Object Expression”;“Failed to execute the expression for business object ‘Decision Override\Subtype’. Check the object properties.”;“Subtype”;
“ERROR”;“Check Business Object Expression”;“Failed to execute the expression for business object ‘Decision Override\Totgrossbill’. Check the object properties.”;“Totgrossbill”;
“ERROR”;“Check Business Object Expression”;“Failed to execute the expression for business object ‘Decision Override\System Decision’. Check the object properties.”;“System Decision”;
“ERROR”;“Check Business Object Expression”;“Failed to execute the expression for business object ‘Decision Override\System Recomended Amount’. Check the object properties.”;“System Recomended Amount”;
“ERROR”;“Check Business Object Expression”;“Failed to execute the expression for business object ‘Decision Override\System Dec Reason’. Check the object properties.”;“System Dec Reason”;
“ERROR”;“Check Business Object Expression”;“Failed to execute the expression for business object ‘Decision Override\Remarks’. Check the object properties.”;“Remarks”;
“ERROR”;“Check Business Object Expression”;“Failed to execute the expression for business object ‘Decision Override\Decisiondate’. Check the object properties.”;“Decisiondate”;
“ERROR”;“Check Business Object Expression”;“Failed to execute the expression for business object ‘Decision Override\Decisiondate(D)’. Check the object properties.”;“Decisiondate(D)”;
“ERROR”;“Check Business Object Expression”;“Failed to execute the expression for business object ‘Decision Override\Userid’. Check the object properties.”;“Userid”;
“ERROR”;“Check Business Object Expression”;“Failed to execute the expression for business object ‘Decision Override\Decision’. Check the object properties.”;“Decision”;
“ERROR”;“Check Business Object Expression”;“Failed to execute the expression for business object ‘Decision Override\Decision Reason’. Check the object properties.”;“Decision Reason”;
“ERROR”;“Check Business Object Expression”;“Failed to execute the expression for business object ‘Decision Override\Amount’. Check the object properties.”;“Amount”;
“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS.LF$APP_CLAIM.CANONICALID=CLAIMS.LF$APP_ACTIVITY.ACTIVITYCODE in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS.LF$APP_CLAIM.CANONICALID=CLAIMS.LF$APP_ACTIVITY.ACTIVITYCODE”;
“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS.LF$APP_CLAIM.CANONICALID=CLAIMS.LF$APP_FRAUDDETAILS.PARENTCANONICALID(+) in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS.LF$APP_CLAIM.CANONICALID=CLAIMS.LF$APP_FRAUDDETAILS.PARENTCANONICALID(+)”;
“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS.LF$APP_REFFERALS.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS.LF$APP_REFFERALS.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID”;
“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS.LF$APP_VAM_TREATMENT.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS.LF$APP_VAM_TREATMENT.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID”;
“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS.LF$APP_CLAIM.PARENTCANONICALID=CLAIMS.LF$APP_POLICY.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS.LF$APP_CLAIM.PARENTCANONICALID=CLAIMS.LF$APP_POLICY.CANONICALID”;
“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS.LF$APP_ACTIVITY.ACTIVITYCODE=CLAIMS.LF$APP_VAM_PREAUTH.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS.LF$APP_ACTIVITY.ACTIVITYCODE=CLAIMS.LF$APP_VAM_PREAUTH.CANONICALID”;
“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS.LF$APP_ACTIVITY.HOLDINGID=CLAIMS.LF$APP_HOLDING.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS.LF$APP_ACTIVITY.HOLDINGID=CLAIMS.LF$APP_HOLDING.CANONICALID”;
“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS.LF$APP_PERSON.CANONICALID=CLAIMS.LF$APP_EDUCATION.PARENTCANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS.LF$APP_PERSON.CANONICALID=CLAIMS.LF$APP_EDUCATION.PARENTCANONICALID”;
“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS.LF$APP_DOCUMENT_REFRENCE.DOCUMENTREFERENCE=CLAIMS.LF$APP_DOCUMENT_MAPPER.DOCUMENT_REFERENCE in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS.LF$APP_DOCUMENT_REFRENCE.DOCUMENTREFERENCE=CLAIMS.LF$APP_DOCUMENT_MAPPER.DOCUMENT_REFERENCE”;
“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS.LF$APP_ACTIVITY.PARTYID=CLAIMS_LF$APP_PARTY2.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS.LF$APP_ACTIVITY.PARTYID=CLAIMS_LF$APP_PARTY2.CANONICALID”;
“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS.LF$APP_CLAIM.CLAIMKEY=“Party_Relation”.CLAIMKEY in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS.LF$APP_CLAIM.CLAIMKEY=“Party_Relation”.CLAIMKEY”;
“WARNING”;“Check Cardinality Same as Detected”;“The join “Claims_PCS”.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CLAIMKEY in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;““Claims_PCS”.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CLAIMKEY”;
“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS_LF$APP_RELATION3.ORIGINATINGOBJECTID=CLAIMS_LF$APP_POLICY3.PARENTCANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS_LF$APP_RELATION3.ORIGINATINGOBJECTID=CLAIMS_LF$APP_POLICY3.PARENTCANONICALID”;
“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS_LF$APP_PARTY2.CANONICALID=CLAIMS_LF$APP_RELATION3.RELATEDOBJECTID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS_LF$APP_PARTY2.CANONICALID=CLAIMS_LF$APP_RELATION3.RELATEDOBJECTID”;
“WARNING”;“Check Cardinality Same as Detected”;“The join HOSPITAL_ID.CLAIMKEY=CLAIMS.LF$APP_CLAIM.CLAIMKEY in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“HOSPITAL_ID.CLAIMKEY=CLAIMS.LF$APP_CLAIM.CLAIMKEY”;
“WARNING”;“Check Cardinality Same as Detected”;“The join LADETAILS.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“LADETAILS.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID”;
“WARNING”;“Check Cardinality Same as Detected”;“The join MAX_FINAL_DECISION_DATE.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“MAX_FINAL_DECISION_DATE.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID”;
“WARNING”;“Check Cardinality Same as Detected”;“The join LAST_DOCUMENT_RECEIVED.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“LAST_DOCUMENT_RECEIVED.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID”;
“WARNING”;“Check Cardinality Same as Detected”;“The join MAX_DECISION_DATE_HCH.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“MAX_DECISION_DATE_HCH.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID”;
Go through all your cardinalities and set them up. This will take an hour or two but will save so much time later.
All clear
Fix them or don’t - it’s up to you. Important if you’re using key/index awareness.
We cannot give you a definite answer on these tables - check for yourself if they should be joined to other tables or not.
If they don’t exist, delete them.
Not something we can help with - your code for your derived table is wrong and needs fixing.
Simple - change the data type!
Some de-bugging for you to do.
[QUOTE]“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS.LF$APP_CLAIM.CANONICALID=CLAIMS.LF$APP_ACTIVITY.ACTIVITYCODE in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS.LF$APP_CLAIM.CANONICALID=CLAIMS.LF$APP_ACTIVITY.ACTIVITYCODE”;
“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS.LF$APP_CLAIM.CANONICALID=CLAIMS.LF$APP_FRAUDDETAILS.PARENTCANONICALID(+) in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS.LF$APP_CLAIM.CANONICALID=CLAIMS.LF$APP_FRAUDDETAILS.PARENTCANONICALID(+)”;
“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS.LF$APP_REFFERALS.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS.LF$APP_REFFERALS.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID”;
“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS.LF$APP_VAM_TREATMENT.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS.LF$APP_VAM_TREATMENT.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID”;
“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS.LF$APP_CLAIM.PARENTCANONICALID=CLAIMS.LF$APP_POLICY.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS.LF$APP_CLAIM.PARENTCANONICALID=CLAIMS.LF$APP_POLICY.CANONICALID”;
“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS.LF$APP_ACTIVITY.ACTIVITYCODE=CLAIMS.LF$APP_VAM_PREAUTH.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS.LF$APP_ACTIVITY.ACTIVITYCODE=CLAIMS.LF$APP_VAM_PREAUTH.CANONICALID”;
“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS.LF$APP_ACTIVITY.HOLDINGID=CLAIMS.LF$APP_HOLDING.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS.LF$APP_ACTIVITY.HOLDINGID=CLAIMS.LF$APP_HOLDING.CANONICALID”;
“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS.LF$APP_PERSON.CANONICALID=CLAIMS.LF$APP_EDUCATION.PARENTCANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS.LF$APP_PERSON.CANONICALID=CLAIMS.LF$APP_EDUCATION.PARENTCANONICALID”;
“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS.LF$APP_DOCUMENT_REFRENCE.DOCUMENTREFERENCE=CLAIMS.LF$APP_DOCUMENT_MAPPER.DOCUMENT_REFERENCE in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS.LF$APP_DOCUMENT_REFRENCE.DOCUMENTREFERENCE=CLAIMS.LF$APP_DOCUMENT_MAPPER.DOCUMENT_REFERENCE”;
“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS.LF$APP_ACTIVITY.PARTYID=CLAIMS_LF$APP_PARTY2.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS.LF$APP_ACTIVITY.PARTYID=CLAIMS_LF$APP_PARTY2.CANONICALID”;
“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS.LF$APP_CLAIM.CLAIMKEY=“Party_Relation”.CLAIMKEY in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS.LF$APP_CLAIM.CLAIMKEY=“Party_Relation”.CLAIMKEY”;
“WARNING”;“Check Cardinality Same as Detected”;“The join “Claims_PCS”.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CLAIMKEY in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;““Claims_PCS”.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CLAIMKEY”;
“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS_LF$APP_RELATION3.ORIGINATINGOBJECTID=CLAIMS_LF$APP_POLICY3.PARENTCANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS_LF$APP_RELATION3.ORIGINATINGOBJECTID=CLAIMS_LF$APP_POLICY3.PARENTCANONICALID”;
“WARNING”;“Check Cardinality Same as Detected”;“The join CLAIMS_LF$APP_PARTY2.CANONICALID=CLAIMS_LF$APP_RELATION3.RELATEDOBJECTID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“CLAIMS_LF$APP_PARTY2.CANONICALID=CLAIMS_LF$APP_RELATION3.RELATEDOBJECTID”;
“WARNING”;“Check Cardinality Same as Detected”;“The join HOSPITAL_ID.CLAIMKEY=CLAIMS.LF$APP_CLAIM.CLAIMKEY in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“HOSPITAL_ID.CLAIMKEY=CLAIMS.LF$APP_CLAIM.CLAIMKEY”;
“WARNING”;“Check Cardinality Same as Detected”;“The join LADETAILS.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“LADETAILS.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID”;
“WARNING”;“Check Cardinality Same as Detected”;“The join MAX_FINAL_DECISION_DATE.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“MAX_FINAL_DECISION_DATE.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID”;
“WARNING”;“Check Cardinality Same as Detected”;“The join LAST_DOCUMENT_RECEIVED.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“LAST_DOCUMENT_RECEIVED.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID”;
“WARNING”;“Check Cardinality Same as Detected”;“The join MAX_DECISION_DATE_HCH.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.”;“MAX_DECISION_DATE_HCH.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID”;
regards,
Ravi/[QUOTE]
See above about cardinalities
(BOB member since 2002-08-15)
(BOB member since 2003-11-27)
(BOB member since 2002-06-06)
(BOB member since 2006-11-01)