When Using Non-English Database with Data Source for Communication Generation with a Deleted Query, Get Error (14015,6) (Doc ID 2210864.1)

Last updated on DECEMBER 05, 2016

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR  
-----------------------
When you go to register a datasource in your base language and it contains a query that has been deleted from your list of queries, the datasource registers fine. However, when a user logs into a non base language, and registers the datasource with invalid queries, they get an error which notes that one of the queries in the datasource is invalid or deleted.

EXPECTED BEHAVIOR
-----------------------
Expect the datasource to give the same error in base language that it gives in non base language.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go into database in ENG, go to Reporting Tools - Query Manager, and copy the query QA_CS_CC_COMMGEN_CGO_AVIN and save it as QA_CS_CC_COMMGEN_CGO_AVSS.
2. Go to Campus Community - Communications - Setup Comms - Communication Datasource and open the DataSource QA_CS_CGO_DATASOURCE. Add the Query QA_CS_CC_COMMGEN_CGO_AVSS to it. Register this datasource.
3. Go back to Query Manager and delete the query QA_CS_CC_COMMGEN_CGO_AVSS.
4. Go back to the Communication Datasource page and again open the same DataSource QA_CS_CGO_DATASOURCE, which should have two queries on it. Delete the query QA_CS_CC_COMMGEN_CGO_AVIN. The datasource must now be registered.
5. Register the datasource and it registers fine, despite having an invalid query in it!
6. Sign out of CS.
7.  Sign back in using the language of CFR.
8. Go back to the Communication Datasource page and again open the same DataSource QA_CS_CGO_DATASOURCE. Add a row to the query area and then delete that new row. Now register the datasource again.
9. The expected error below is displayed:


Erreur survenue à l'ouverture de l'interrogation PS . (14015,6)
SCC_COMMGEN.Model.DSAdapters.PSQueryAdapter.OnExecute  Name:Validate  PCPC:772  Statement:14
Called from:SCC_COMMGEN.Model.CommGen.OnExecute  Name:InitializeCommGenDS  Statement:559
Called from:SCC_COMMGEN.Model.CommGen.OnExecute  Name:RegisterDataSource  Statement:28
Called from:SCC_CG_DTASRC.GBL.DERIVED_CC.SCC_CG_PARMS.FieldChange  Statement:132

Il est impossible d'ouvrir l'interrogation PS référencée.  Assurez-vous que cette interrogation existe bien dans le Gestionnaire des interrogations PS.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot be sure the datasource is correct.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms