on 06-04-2015 8:56 AM
Hello SCN,
I am facing an error while running a data loading procedure, which is not consistent as shown below:
column store error: search table error: [23007] Join graph not connected;join not connected
Would like to know if any one faced this error or what would be the likely cause for this error.
Any inputs would be helpful.
Regards,
Krishna Tangudu
Problem was with one attribute view which he used in building the calculation view . Tables underlying the attribute vie was partitioned and that made inconsitency in the scritp . Its now corrected .
Sree
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I faced this issue before . This is a problem with data in joined tables. Some inconsistencies . This inconsistency(only in the data ) is not existing in production , hence no error there . My issue was - I maintained carnality of join , and the same was not matching with the data available in the table. I corrected the carnality and it went through .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Krishna,
Could you please tell us when did you see this error - while running the algorithm or just the data source?
Thanks,
Supriya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sumeet,
Yes the calculation view is active, the error message is not consistent it is giving error sometimes and getting successful randomly. The same code in Production system is getting successful all the times.
So not sure why is it giving errors, But yes am checking the join conditions one more time
Regards
Krishna Tangudu
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.