Versions Compared

Old Version 2

changes.mady.by.user Knowledge Assistant

Saved on

compared with

New Version 3

changes.mady.by.user Knowledge Assistant

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleDescription of Issue
  • AR Cube failing with the error Ambiguous column name ‘Comment’. during the JorunalAccountPairs query. 
  • DFT - Load stg_AR_JournalAccountPairs:Error: SSIS Erros Code DTS_E_OLEDBERROR. An OLE DB error has occurred. 
  • The batch could not be analyzed because of compile errors.
  • Ambiguous column name 'Comment.'
Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleContext
  • Accounts Receivable
  • AR Cube
  • Step 3 CubeGeneral Billing
  • Accounts Receivable
Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleCause

UndeterminedA table is not specified in a SQL query that is running. The query needs to be corrected. 

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleResolution

Please contact Enterprise ERP GB & Misc Cash SupportDevelopment is currently working on correcting this issue. Please contact General Billing Support for additional updates. 

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleAdditional Information

To determine why a Cubes Job is failing, please see: Generate An Error Report For Failed Cubes Job

...