Found another thing. I created a user with special characters " (double quotes), ' (single quote), ! (exclamation), and the CABI integration report OCA_Abuse exception.
Another ticket for CA...
Jan 20, 2012 3:42:54 PM - Error invoking query on CMS:
com.crystaldecisions.sdk.exception.SDKServerException: Not a valid query. (FWB
00025)
cause:com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuse:
IDL:img.seagatesoftware.com/OCA/oca_abuse:3.2
detail:Not a valid query. (FWB 00025)
The server supplied the following details: OCA_Abuse exception 7683 at
[InfoStore.cpp : 2991] 48163 {}
...Error generating parse treeSELECT * FROM CI_SYSTEMOBJECTS WHERE
SI_PROGID='CrystalEnterprise.User' AND SI_NAME='"sdjkf!''
Jan 20, 2012 3:42:55 PM - Error invoking query on CMS:
com.crystaldecisions.sdk.exception.SDKServerException: Not a valid query. (FWB
00025)
cause:com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuse:
IDL:img.seagatesoftware.com/OCA/oca_abuse:3.2
detail:Not a valid query. (FWB 00025)
The server supplied the following details: OCA_Abuse exception 7683 at
[InfoStore.cpp : 2991] 48163 {}
...Error generating parse treeSELECT * FROM CI_SYSTEMOBJECTS WHERE
SI_PROGID='CrystalEnterprise.User' AND SI_NAME='"sdjkf!''
Jan 20, 2012 3:42:55 PM - Error initializing the Reporting Integration.
java.lang.NullPointerException
at
com.aprisma.spectrum.app.repmgr.re.bo.CrystalUserManager.processUser(CrystalUserManager.java:311)
at
com.aprisma.spectrum.app.repmgr.re.bo.CrystalUserManager.processUserList(CrystalUserManager.java:257)
at
com.aprisma.spectrum.app.repmgr.re.bo.CrystalUserManager.synchronizeUsers(CrystalUserManager.java:203)
at
com.aprisma.spectrum.app.repmgr.re.bo.CrystalReportingInitializer.initializeReporting(CrystalReportingInitializer.java:176)
at
com.aprisma.spectrum.app.repmgr.re.bo.CrystalReportingInitializer$CrystalReportingInitializerTask.run(CrystalReportingInitializer.java:272)
at java.lang.Thread.run(Thread.java:619)
From: Bohra, Saurabh [mailto:[email protected]]
Sent: Tuesday, January 17, 2012 5:32 PM
To: spectrum
Cc: spectrum ([email protected])
Subject: RE: [spectrum] Space character and username & password
To my surprise, I created users with a lot of special characters in name and
password - that worked too...
As per support it is Functioning as designed (FAD) and CA might have removed
all the restrictions from username and password field for usage of any special
character.
In our DEV environment, I have EEM integration of Spectrum and eHealth (both
distributed). Reports launched from Spectrum with username having a Space
character is not liked by any reports that are supposed to run on ehealth
pollers (like trend, live reporting, performance dashboard), however AAG report
which runs on ehealth RFE works (magically) - I have opened another ticked.
To me it's not well thought of design than bug/ enhancement tickets to patch
the product.
Saurabh Bohra
O: 860-766-0842 | M: 860-385-3597 | e-mail:
[email protected]<mailto:[email protected]>
From: Ferber, Raymond J
[mailto:[email protected]]<mailto:[mailto:[email protected]]>
Sent: Tuesday, January 17, 2012 5:19 PM
To: Bohra, Saurabh
Subject: RE: [spectrum] Space character and username & password
I did the same copy & paste userid build, experienced the exact challenge, and
scratched my head attempting to figure out why the new user I created did not
work . . . We also run a DSS 9.2.1 RHEL environment.
Thanks
Raymond Ferber
IT Architect
[cid:[email protected]]
Office 402-777-1868
Mobile 402-960-5126
[email protected]<mailto:[email protected]>
From: Bohra, Saurabh
[mailto:[email protected]]<mailto:[mailto:[email protected]]>
Sent: Tuesday, January 17, 2012 2:48 PM
To: spectrum
Subject: [spectrum] Space character and username & password
Hello Spectrum World,
We are running Spectrum 9.2 SP1 on RHEL.
While recreating a user in Spectrum, I accidently created a user with a leading
space character (I was trying to save some time by copy/paste). Then by
curiosity, I created another user and by surprise I found that I was able to
create user in spectrum with either leading or trailing or "in between" space
character. I found the same was true for password field. Has anyone else seen
this before?
I have opened a ticket with support to find out more details.
Cheers,
Saurabh Bohra
Sr. Network Mgmt Systems Analyst
ESPN Inc.
O: 860-766-0842 | M: 860-385-3597 | e-mail:
[email protected]<mailto:[email protected]>
* --To unsubscribe from spectrum, send email to
[email protected]<mailto:[email protected]> with the body: unsubscribe spectrum
[email protected]<mailto:[email protected]>
________________________________
The information in this message may be proprietary and/or confidential, and
protected from disclosure. If the reader of this message is not the intended
recipient, or an employee or agent responsible for delivering this message to
the intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited. If you
have received this communication in error, please notify First Data immediately
by replying to this message and deleting it from your computer.
________________________________
Please consider the environment before printing this e-mail.
* --To unsubscribe from spectrum, send email to
[email protected]<mailto:[email protected]> with the body: unsubscribe spectrum
[email protected]<mailto:[email protected]>
---
To unsubscribe from spectrum, send email to [email protected] with the body:
unsubscribe spectrum [email protected]<<inline: image001.png>>
