After updating a 2010 install to 2012 we noticed two companies won't integrate. The integration log is giving this error over and over:
[GL Transaction to Fact] has encountered an error. Processing will be aborted. Error text: The multi-part identifier "seg1.ACCATNUM" could not be bound.
Operand data type void type is invalid for max operator.
The data types void type and nchar are incompatible in the CTCrVersionAgg operator.
Operand data type void type is invalid for max operator.
The data types void type and nchar are incompatible in the CTCrVersionAgg operator.
The multi-part identifier "seg0.ACTDESCR" could not be bound.
The multi-part identifier "seg1.ACCATNUM" could not be bound.
The multi-part identifier "seg1.ACCATNUM" could not be bound.
Operand data type void type is invalid for max operator.
The data types void type and nchar are incompatible in the CTCrVersionAgg operator.
Operand data type void type is invalid for max operator.
The data types void type and nchar are incompatible in the CTCrVersionAgg operator.
The multi-part identifier "seg0.ACTDESCR" could not be bound.
The multi-part identifier "seg1.ACCATNUM" could not be bound.
The multi-part identifier "seg1.ACCATNUM" could not be bound.
Operand data type void type is invalid for max operator.
The data types void type and nchar are incompatible in the CTCrVersionAgg operator.
The multi-part identifier "seg0.ACTDESCR" could not be bound.
The multi-part identifier "seg1.ACCATNUM" could not be bound.
Has anyone seen this yet, or a way to get through it?
*This post is locked for comments
In our instance it occurred because a company had been defined and never set up so there weren't any GL accounts in it. Once the company without any gl accounts was deleted it worked fine.
I have just encountered it with a new install of MR 2012 CU7...has anyone resolved it? Thank you.
I don't believe we have.
I received the same error. did you get this resolved?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156