My Oracle Support Banner

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 JANUARY 26, 2020

Applies to:

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

Symptoms

 
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.

 
Expect the datasource to give the same error in base language that it gives in non base language.
 
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) ( in english: Error ound when opening PS Query.)
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.(in english: You can not open the referenced PS query. Make sure this query exists in the PS Query Manager.)

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


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