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.

N/A

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/

How to resolve the issue - " Microsoft OLE DB Provider for SQL Server Invalid object name 'CSSAMP'....." in Statistica?