/
AR Cube Failure Due To Ambiguous Column Name
AR Cube Failure Due To Ambiguous Column Name
- Knowledge Assistant
- Moriah Yorkey
Owned by Knowledge Assistant
Description 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.'
Context
Accounts Receivable
AR Cube
Step 3 Cube
Cause
A table is not specified in a SQL query that is running. The query needs to be corrected.
Resolution
Development is currently working on correcting this issue. Please contact General Billing Support for additional updates.
Additional Information
To determine why a Cubes Job is failing, please see: Generate An Error Report For Failed Cubes Job
, multiple selections available,
Related content
Master Article - Nightly Cubes Job Failing at Step 1
Master Article - Nightly Cubes Job Failing at Step 1
More like this
AR Cube Failure Due to Bad Paid By Customer Data Created by Importing Unsupported File Type Via Process Lockbox File
AR Cube Failure Due to Bad Paid By Customer Data Created by Importing Unsupported File Type Via Process Lockbox File
More like this
Nightly Cubes Job Failing at Step 1 - SQL Analysis Collation mismatch
Nightly Cubes Job Failing at Step 1 - SQL Analysis Collation mismatch
More like this
Error in Aging Report - Invalid column_name cust_acct
Error in Aging Report - Invalid column_name cust_acct
More like this
Maryland Create Accounts Receivable Error inserting Charge Credit record
Maryland Create Accounts Receivable Error inserting Charge Credit record
More like this
Nightly Cubes Job Failing on Step 4 with invoice description duplicate attribute key error
Nightly Cubes Job Failing on Step 4 with invoice description duplicate attribute key error
More like this