We are using Information Analyzer 8.1.2 fix pack 3 on IIS client/server. If the length of user name used to run IA jobs is less than 64 characteres, all IA jobs run fine. On the other hand if the length of user name used to run IA jobs is more than 64 characters, we get the below error.
------------------------------------------------------------------------
[10/6/10 9:33:48:919 UTC] 00000037 ExceptionUtil E CNTR0020E: EJB
threw an unexpected (non-declared) exception during invocation of
method "setTaskScheduleStatus" on bean "BeanId(ACS_server.
ear#ACS_server.jar#SchedulerListener, null)". Exception data: javax.ejb.
EJBException: nested exception is: com.ascential.acs.scheduling.server.
impl.TaskScheduleDAOException: com.ascential.asb.util.sandbox.
DataAccessException: com.ascential.xmeta.exception.data.
DataLengthConstraintViolationException: A data length constraint was
violated on attribute "_xmeta_modified_by_user". The maximum allowed
length is 64, but the length of the value is 66. The value is "uid=s-
piiisadmlab-u-global,ou=ServiceAccounts,ou=Global,o=ikea.com". The RID
of the object is "d70c6594.80cb2b5c.47d676fc.197d6919-179b-4bf2.be21.
bb0f22bb218c". The displays attribute "null" has the value "null"
com.ascential.acs.scheduling.server.impl.TaskScheduleDAOException: com.
ascential.asb.util.sandbox.DataAccessException: com.ascential.xmeta.
exception.data.DataLengthConstraintViolationException: A data length
constraint was violated on attribute "_xmeta_modified_by_user". The
maximum allowed length is 64, but the length of the value is 66. The
value is "uid=s-piiisadmlab-u-global,ou=ServiceAccounts,ou=Global,
o=ikea.com". The RID of the object is "d70c6594.80cb2b5c.47d676fc.
197d6919-179b-4bf2.be21.bb0f22bb218c". The displays attribute "null"
has the value "null"
------------------------------------------------------------------------
Any help on this is appreciated.
Unable to do column analysis using IA 8.1.2 Fix Pack 3
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Could be worth checking the XMETA database to determine whether the job name property for an IA job is data type VarChar(64). At the moment (weekend) I can't perform that check. But that would be my guess as to the cause.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Do you have a really long user id? Is "s-piiisadmlab-u-global" part of your user id? Just wondering if you could fix this problem by creating a shorter user name.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Actually we are using external registry (LDAP) and here it takes the complete qualified user name in case of IA. In this case the qualified user name is uid=s-piiisadmlab-u-global,ou=ServiceAccounts,ou=Global,o=ikea.com and its length comes out to be 66 characters.
As a work around, we have started creating LDAP users with qualified user name length less than 64 characters.
As a work around, we have started creating LDAP users with qualified user name length less than 64 characters.
Arvind
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: