Unable to Create New Data Sheet

Technote (troubleshooting)


Problem(Abstract)

Receive error while creating new record in Datasheet (Cal) after enabling the Autokey prefix with 'AP' and 'NA'.

Symptom

Steps:

1. Go to Organizations application, select action menu > Autonumber Setup > System Level

2. Filter for autonumbers that start with Plus
Enter AP as the prefix for PLUSCDSINSTRINSTRSEQ and PLUSCWODSWODSNUM





3. Select action menu > Autonumber Setup > Organization Level
Enter AP as the prefix for PLUSCWODSWODSNUM


4. Select action menu > Autonumber Setup > Site Level
Enter AP as the prefix for PLUSCWODSWODSNUM




5. Go to Planning > Data Sheet Template, click New, and then click New Row under Asset Functions within the Data Sheet tab. Get error:

BMXAA420E - Database error number 245 has occurred
[KLM1SQL01V501\MAXIMO]Conversion failed when converting the varchar
value 'AP0000001234' to data type int.

Cause

Excerpt from the SQL log:


select seed, prefix from autokey
where autokeyname = 'PLUSCDSINSTRINSTRSEQ'
and orgid is null and siteid is null

Run the query below:

SELECT OBJECTNAME,ATTRIBUTENAME,MAXTYPE FROM MAXATTRIBUTE
WHERE 'PLUSCDSINSTRINSTRSEQ'

output: PLUSCDSINSTR.INSTRSEQ

Run the query below:
SELECT OBJECTNAME,ATTRIBUTENAME,MAXTYPE FROM MAXATTRIBUTE
WHERE ATTRIBUTENAME='INSTRSEQ '

Since we have a autokey prefix of 'NA', INTEGER data type for INSTRSEQ will not support STRING.


Resolving the problem

Currently Data Sheet Template and Data Sheet referenced in work orders only support integer data type and does not support VARCHAR data type. Either that we don't setup any prefixes or we must use INTEGER as the prefix in the organization application, autonumber setup for data sheet to work properly.



Steps:
1. Go to the Organizations application, bring up the appropriate organization, go to select actions menu, autonumber setup, organization level, change the prefix for PLUSCWODSWODSNUM to an integer

2. Go to the Organizations application, bring up the appropriate organization, go to select actions menu, autonumber setup, systemlevel, change the prefix for PLUSCDSINSTRINSTRSEQ and PLUSCWODSWODSNUM to an integer

3. Go to Planning module, Data Sheet Template application, click New, and then click New Row under Asset Functions within the Data Sheet tab, enter a new asset function. There will not be any error any more.


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM Maximo Calibration
Calibration

Software version:

6.4, 6.5, 7.1, 7.1.2, 7.2.1, 7.5

Operating system(s):

AIX, HP-UX, Linux, Windows

Reference #:

1507200

Modified date:

2013-06-24

Translate my page

Machine Translation

Content navigation