| Author |
Message |
rvrsarma.1982
Senior Member
Joined: 05 Oct 2018
Posts: 34
|
 Posted: Sat Oct 06, 2018 7:09 am
Post subject: converting .UNV to.UNX using IDT in 4.1 |
|
|
Dear friends,
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...
| Code: |
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
|
... *** SNIP ** By Moderator Andreas
[Moderator Edit: Added code formatting - Andreas]
Last edited by rvrsarma.1982 on Sat Oct 06, 2018 8:39 am, edited 1 time in total |
|
| Back to top |
|
|
Nick Daniels
Forum Aficionado
Joined: 15 Aug 2002
Posts: 14246
Location: England
|
Posted: Sat Oct 06, 2018 8:04 am
Post subject: Re: converting .UNV to.UNX using IDT in 4.1 |
|
|
| A View / Refresh Structure before conversion might be a good idea. |
|
| Back to top |
|
|
Marek Chladny
Forum Advocate
Joined: 27 Nov 2003
Posts: 19326
Location: Bratislava
|
Posted: Mon Oct 08, 2018 3:49 am
Post subject: Re: converting .UNV to.UNX using IDT in 4.1 |
|
|
| [Moderator Note: Moved from General Discussion to Semantic Layer / Universe Designer] |
|
| Back to top |
|
|
Mark P
Forum Devotee
Joined: 03 Feb 2003
Posts: 11493
Location: Manchester, UK
|
Posted: Mon Oct 08, 2018 4:35 am
Post subject: Re: converting .UNV to.UNX using IDT in 4.1 |
|
|
| Nick Daniels wrote: | | A View / Refresh Structure before conversion might be a good idea. |
Then follow that up with setting all the cardinalities on the joins. 
_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS
______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996! |
|
| Back to top |
|
|
Dave Rathbun
Forum Advocate
Joined: 06 Jun 2002
 *16
Posts: 22156
Location: Dallas, Texas
|
|
| Back to top |
|
|
Mark P
Forum Devotee
Joined: 03 Feb 2003
Posts: 11493
Location: Manchester, UK
|
Posted: Mon Oct 08, 2018 9:11 am
Post subject: Re: converting .UNV to.UNX using IDT in 4.1 |
|
|
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.
_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS
______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996! |
|
| Back to top |
|
|
rvrsarma.1982
Senior Member
Joined: 05 Oct 2018
Posts: 34
|
Posted: Tue Oct 09, 2018 1:25 pm
Post subject: Re: converting .UNV to.UNX using IDT in 4.1 |
|
|
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
1) Initially refresh structure and export to repository.
2) 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
regards,
Ravi |
|
| Back to top |
|
|
Nick Daniels
Forum Aficionado
Joined: 15 Aug 2002
Posts: 14246
Location: England
|
Posted: Tue Oct 09, 2018 1:46 pm
Post subject: Re: converting .UNV to.UNX using IDT in 4.1 |
|
|
| I guess you need a step 1a) remediate problems following View / Refresh Structure. |
|
| Back to top |
|
|
Mark P
Forum Devotee
Joined: 03 Feb 2003
Posts: 11493
Location: Manchester, UK
|
Posted: Wed Oct 10, 2018 2:36 am
Post subject: Re: converting .UNV to.UNX using IDT in 4.1 |
|
|
| Nick Daniels wrote: | | I guess you need a step 1a) remediate problems following View / Refresh Structure. |
Agreed. View/Refresh Structure, then fix the problems that we've pointed out and then post a revised integrity check on here.
_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS
______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996! |
|
| Back to top |
|
|
rvrsarma.1982
Senior Member
Joined: 05 Oct 2018
Posts: 34
|
Posted: Wed Oct 10, 2018 8:10 am
Post subject: Re: converting .UNV to.UNX using IDT in 4.1 |
|
|
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)
2) 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.
regards,
Ravi.  |
|
| Back to top |
|
|
Mark P
Forum Devotee
Joined: 03 Feb 2003
Posts: 11493
Location: Manchester, UK
|
Posted: Wed Oct 10, 2018 9:28 am
Post subject: Re: converting .UNV to.UNX using IDT in 4.1 |
|
|
Issue 1) You need to set up the ODBC drivers on the new 4.1 server both 32-bit and 64-bit.
_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS
______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996! |
|
| Back to top |
|
|
rvrsarma.1982
Senior Member
Joined: 05 Oct 2018
Posts: 34
|
Posted: Fri Oct 12, 2018 8:20 am
Post subject: Re: converting .UNV to.UNX using IDT in 4.1 |
|
|
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.,
after that my report is got success through CMC as well as in BI launch pad also too.
Regards,
Ravi |
|
| Back to top |
|
|
Mark P
Forum Devotee
Joined: 03 Feb 2003
Posts: 11493
Location: Manchester, UK
|
Posted: Fri Oct 12, 2018 9:00 am
Post subject: Re: converting .UNV to.UNX using IDT in 4.1 |
|
|
| rvrsarma.1982 wrote: | 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.,
after that my report is got success through CMC as well as in BI launch pad also too.
Regards,
Ravi |
I did mention it two days ago....
| Mark P wrote: | | Issue 1) You need to set up the ODBC drivers on the new 4.1 server both 32-bit and 64-bit. |
_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS
______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996! |
|
| Back to top |
|
|
rvrsarma.1982
Senior Member
Joined: 05 Oct 2018
Posts: 34
|
Posted: Sat Oct 13, 2018 7:57 am
Post subject: Re: converting .UNV to.UNX using IDT in 4.1 |
|
|
| Mark P wrote: | | Nick Daniels wrote: | | I guess you need a step 1a) remediate problems following View / Refresh Structure. |
Agreed. View/Refresh Structure, then fix the problems that we've pointed out and then post a revised integrity check on here. |
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";
regards,
Ravi |
|
| Back to top |
|
|
surya_sudheer
Forum Associate
Joined: 01 Nov 2006
Posts: 683
Location: Chennai
|
Posted: Mon Oct 15, 2018 12:38 am
Post subject: Re: converting .UNV to.UNX using IDT in 4.1 |
|
|
Whatever the db people do at the database level, you have to refresh the universe structure and you will not get those errors
_________________
SAP BO, BW, Crystal Reports, Tableau |
|
| Back to top |
|
|
|
