RS03403: MODEL ADDITIONS NOT DETECTED IF DATABASE SCHEMA IS USING SYNONYMS

Fixes are available

APAR status

Closed as program error.

Error description

Some customers use synonyms to access DC tables in a different
database schema.
In that case, the model additions check does not work properly
which causes exceptions such as : java.sql.SQLException:
ORA-00904: "BC_USER"."BASELINE"."RGT": invalid identifier.

Local fix

```
Do not use synonyms
```

Problem summary

****************************************************************
* USERS AFFECTED:                                              *
* Decision Center users.                                       *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* Decision Center database tables do not properly handle       *
* synonyms.                                                    *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

Problem conclusion

```
The code was fixed.
```

Temporary fix

```
Do not use synonyms.
```

Comments

APAR Information

APAR number
RS03403
Reported component name
WS DECISION CTR
Reported component ID
5725B6900
Reported release
892
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-06-20
Closed date
2019-06-21
Last modified date
2019-06-21

APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:

Fix information

Fixed component name
WS DECISION CTR
Fixed component ID
5725B6900

Applicable component levels

R892 PSY
UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSQP76","label":"IBM Operational Decision Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"892","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
24 November 2021

Tips

RS03403: MODEL ADDITIONS NOT DETECTED IF DATABASE SCHEMA IS USING SYNONYMS

Fixes are available

Subscribe

APAR status

Closed as program error.

Error description

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

APAR number

Reported component name

Reported component ID

Reported release

Status

PE

HIPER

Special Attention

Submitted date

Closed date

Last modified date

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Fix information

Fixed component name

Fixed component ID

Applicable component levels

R892 PSY

Document Information

Share your feedback

Need support?