Assignment Manager Task Fails With Error "Column TEER_ID Does Not Exist In Table S_TERRALGN_PSTN. Make Sure Your Diccache.dat Is Up To Date." (Doc ID 2932081.1)

Last updated on MARCH 01, 2023

Applies to:

Symptoms

Siebel application environment has been upgraded from 8.1.1.7 to 22.9.

Once on the Siebel 22.9 version, when running the Assignment Manager task to assign service request records, it fails with an error.

The following error message occurs in the AsgnSrvr*.log file:

The behaviour occurs as follows:

1. Follow the Siebel documentation to upgrade the Siebel application environment from 8.1.1.7 to 22.9:

https://docs.oracle.com/cd/F26413_37/books/UPG/index.html

2. Start the Siebel 22.9 environment services

3. Log into Siebel Client UI, select a service request record

4. Click the Assign button to assign the service request.

5. This starts an AsgnSrvr task.

6. The AsgnSrvr task fails with the reported error.

Changes

The environment was upgraded from Siebel 8.1.1.7 to 22.9

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.