BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

converting .UNV to.UNX using IDT in 4.1

Goto page 1, 2  Next
 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
rvrsarma.1982
Senior Member
Senior Member



Joined: 05 Oct 2018

Posts: 33



PostPosted: 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
Forum Aficionado



Joined: 15 Aug 2002

Posts: 14239
Location: England


flag
PostPosted: 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
Forum Advocate



Joined: 27 Nov 2003

Posts: 19318
Location: Bratislava


flag
PostPosted: 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
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11453
Location: Manchester, UK


flag
PostPosted: 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. icon_smile.gif

_________________
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
Forum Advocate



Joined: 06 Jun 2002

speaker.gif*16
Posts: 22140
Location: Dallas, Texas


flag
PostPosted: Mon Oct 08, 2018 8:53 am 
Post subject: Re: converting .UNV to.UNX using IDT in 4.1

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.
_________________
Dave's Adventures in Business Intelligence Image link

Latest Blog Posts
• 2019-09-19 Stephen Few Blog Post on Multivariate Visualization
• 2019-02-11 Update on Query Banding
• 2018-10-19 BI Evolution
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11453
Location: Manchester, UK


flag
PostPosted: 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
Senior Member



Joined: 05 Oct 2018

Posts: 33



PostPosted: 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
Forum Aficionado



Joined: 15 Aug 2002

Posts: 14239
Location: England


flag
PostPosted: 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
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11453
Location: Manchester, UK


flag
PostPosted: 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
Senior Member



Joined: 05 Oct 2018

Posts: 33



PostPosted: 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. banghead.gif
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11453
Location: Manchester, UK


flag
PostPosted: 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. icon_smile.gif
_________________
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
Senior Member



Joined: 05 Oct 2018

Posts: 33



PostPosted: 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.

seeya.gif

Regards,
Ravi
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11453
Location: Manchester, UK


flag
PostPosted: 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.

seeya.gif

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. icon_smile.gif


icon_wink.gif

_________________
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
Senior Member



Joined: 05 Oct 2018

Posts: 33



PostPosted: 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
Forum Associate



Joined: 01 Nov 2006

Posts: 683
Location: Chennai


flag
PostPosted: 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
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 2 All times are GMT - 5 Hours
Goto page 1, 2  Next
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0996 seconds using 18 queries. (SQL 0.0023 Parse 0.0630 Other 0.0343)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo