How to resolve the issue - " Microsoft OLE DB Provider for SQL Server Invalid object name 'CSSAMP'....." in Statistica?
Article ID: KB0072731
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 13.5,13.6,14.0 |
Description
Sometimes Statistica Enterprise users may encounter the following issue while making data configuration off data entry setup in Statistica.
Error Screenshot -
Error message grabbed from the above image :
Microsoft OLE DB Provider for SQL Server
Invalid object name 'CSSAMP".
Occurred when:
Open recordset
SQL Statement:
SELECT D.SAMPID AS SampleID, D.CTIME AS CreateDate,
LO.LABVALUE AS CreateUser, L1.LABVALUE AS Station,
L2.LABVALUE AS Lot_13.LABVALUE AS Batch_Record,
L4.LABVALUE AS Current_Stage, L5.LABVALUE AS Status,
L6.LABVALUE AS Issues_Events, CAST (L8.LABVALUE AS
DATETIME) AS Date_, CAST(L9.LABVALUE AS DATETIME) AS
Time, D.PIECENO AS PieceNumber, CO.VARVALUE AS Passage
Statistica Enterprise users can refer to the following solution to get rid of this issue.
Error Screenshot -
Error message grabbed from the above image :
Microsoft OLE DB Provider for SQL Server
Invalid object name 'CSSAMP".
Occurred when:
Open recordset
SQL Statement:
SELECT D.SAMPID AS SampleID, D.CTIME AS CreateDate,
LO.LABVALUE AS CreateUser, L1.LABVALUE AS Station,
L2.LABVALUE AS Lot_13.LABVALUE AS Batch_Record,
L4.LABVALUE AS Current_Stage, L5.LABVALUE AS Status,
L6.LABVALUE AS Issues_Events, CAST (L8.LABVALUE AS
DATETIME) AS Date_, CAST(L9.LABVALUE AS DATETIME) AS
Time, D.PIECENO AS PieceNumber, CO.VARVALUE AS Passage
Statistica Enterprise users can refer to the following solution to get rid of this issue.
Issue/Introduction
How to resolve the issue - " Microsoft OLE DB Provider for SQL Server Invalid object name 'CSSAMP'....." in Statistica?
Environment
N/A
Resolution
1) Navigate to "System options > Data Entry" in Statistica Enterprise
2) Check " Default database connection for creating Data Configurations off Data Entry Setups " and select the database connection having Statistica meta database repository because Data Configuration of Data Entry Setup requires sample IDs & CSSAMP table in metadatabase stores data entry sample IDs.
3) Try to create a Data Configuration of Data Entry Setup again.
If users are still observing a similar issue, please feel free to contact TIBCO Support at https://support.tibco.com/s/
2) Check " Default database connection for creating Data Configurations off Data Entry Setups " and select the database connection having Statistica meta database repository because Data Configuration of Data Entry Setup requires sample IDs & CSSAMP table in metadatabase stores data entry sample IDs.
3) Try to create a Data Configuration of Data Entry Setup again.
If users are still observing a similar issue, please feel free to contact TIBCO Support at https://support.tibco.com/s/
Feedback
Yes
No
Powered by
