Differences between 2.2.2 and 2.1.2

I have a script I wrote for 2.2.2 before we were told we had to use 2.1.2 for the verion of maximo we are using. The script worked the way it should it 2.2.2 and does nothing in 2.1.2. Does any one have a troubleshooting idea for this? I receive no errors or results with the script in 2.1.2.
Thanx in advance

Find more posts tagged with

Comments

mwilliams

Hi 19nigel91,

Did you recreate the report completely? Or did you just change the version info in the xml source? Also, is the entire report not running correctly, or is it just not doing what your script was supposed to do?

19nigel91

We attempted to import and change the XML, no dice.
I get the column headers but no results populate,
I am working on rebuilding...again.

19nigel91

2.1.2 does not seem to accept the parameter marker ? when a sub query is involved. It appears to accept a : again, I do not get results.
I worked through each of the parameters in the script replacing : with ? I received interesting results. In the between statement it returned "Invalid relational operator". When I used the ? in the sub queries it returned "Missing right parenthesis" When ? was used in all parameters, "SQL statement not properly ended" is returned." It is the same query I used in 2.2.2.

19nigel91

I also removed all parameters and sub queries, substituted hard values and still receive no results, only column headers.

mwilliams

19nigel91,

So, building the report over again in 2.1.2 didn't work? Did you start from scratch completely when you tried this? Then, just copy and paste the scripts in from the 2.2.2 report? I don't have a copy on my computer prior to 2.2.2, so I'm not able to do any of my own testing on this at the moment.