General Script Error

[#1]

Hi,

Could anyone elaborate on this error please?

In what cases, it may occur? Cuz I am facing this recently and it's so vague that I'm unable to debug.

thanks!!!

[tresesco · Accepted solution]

Some of the possible reasons:

• Synthetic key
• Incorrect Group By clause
• Access permission denial for source data/file

Trying debugging the script with limited record set. That could help.

[#3]

thanks tresesco..

I'm guessing synthetic keys could be the cause..

could you suggest a way to get rid of them?

[Anonymous]

Hi,

PFA document may be use fule.

BR,

Chinna

[tresesco]

Generic ways are like:

•      Rename one set of common keys to something else
•      If most of the fields in the tables are common, possibly, consider concatenating them to form a single table
•      Link table - if the data size is not that big

Edit: I guess it would be worth mentioning that - 'Synthetic keys are not necessarily bad or incorrect'

It depends on your model.