Crystal Report runs in v8.0 but not in 8.5

I have one Crystal Report loaded at the same location (a shared drive) that has worked for years.  It runs fine in Crystal 8.0, but when I attempt to run it in Crystal 8.5, I get the "ORA-01008: not all variables bound" error.  The odd part is, its true, not all variables are bound .. but the report has been working fine in v8.0 for years.  I checked both versions, and the options are set to the same as far as I can see.  The "CLOSE_DATE" parameter is the one giving me fits.  I have copied in the SQL trace from the one that works and the one that doesn't.  So how does v8.0 work and v8.5 not?  I guess if I can't figure that out, I need to figure out how to make it work in v8.5.  Yes, I know we need to upgrade... long story.  Any help would be appreciated.

I have shortened my SQL Statement to remove what I assume is extraneous information.  Notice that the first query does "SQLPrepare", while the second one does SQLExecDirect.  Important difference?

Thanks so much!

===================================
Working SQL Trace:
===================================

crw32           870-8b0      ENTER SQLPrepare
            HSTMT               03531D58
            UCHAR *             0x01356340 [      -3] "SELECT (FIELDS) FROM "EXAV"."PROBLEMS" PROBLEMS, "EXAV"."WORK_HISTORY" WORK_HISTORY, "EXAV"."SESION" SESION, "EXAV"."LOCATION" LOCATION, "EXAV"."GANG" GANG, "EXAV"."USERS" USERS, "EXAV"."UP_DIAGNOSTICS" UP_DIAGNOSTICS, "EXAV"."EXAV_COQ" EXAV_COQ  WHERE PROBLEMS."PROBLEM_CODE" <> 'CLOSED' OR PROBLEMS."CLOSE_DATE" >= ? AND PROBLEMS."CLOSE_DATE" <= ? AND PROBLEMS."CLOSE_TIME" < '06:30:00' OR PROBLEMS."CLOSE_DATE" >= ? AND PROBLEMS."CLOSE_DATE" <= ? AND PROBLEMS."CLOSE_TIME" > '06:30:00') " = 'RA..."            SDWORD                    -3

crw32           870-8b0      EXIT  SQLPrepare  with return code 0 (SQL_SUCCESS)
            HSTMT               03531D58
            UCHAR *             0x01356340 [      -3] "SELECT (FIELDS) FROM "EXAV"."PROBLEMS" PROBLEMS, "EXAV"."WORK_HISTORY" WORK_HISTORY, "EXAV"."SESION" SESION, "EXAV"."LOCATION" LOCATION, "EXAV"."GANG" GANG, "EXAV"."USERS" USERS, "EXAV"."UP_DIAGNOSTICS" UP_DIAGNOSTICS, "EXAV"."EXAV_COQ" EXAV_COQ  WHERE PROBLEMS."PROBLEM_CODE" <> 'CLOSED' OR PROBLEMS."CLOSE_DATE" >= ? AND PROBLEMS."CLOSE_DATE" <= ? AND PROBLEMS."CLOSE_TIME" < '06:30:00' OR PROBLEMS."CLOSE_DATE" >= ? AND PROBLEMS."CLOSE_DATE" <= ? AND PROBLEMS."CLOSE_TIME" > '06:30:00') "            SDWORD                    -3

crw32           870-8b0      ENTER SQLBindParameter
            HSTMT               03531D58
            UWORD                        1
            SWORD                        1 <SQL_PARAM_INPUT>
            SWORD                       11 <SQL_C_TIMESTAMP>
            SWORD                       11 <SQL_TIMESTAMP>
            SQLULEN                   19
            SWORD                        0
            PTR                0x0135B5F8
            SQLLEN                     0
            SQLLEN *            0x00000000

crw32           870-8b0      EXIT  SQLBindParameter  with return code 0 (SQL_SUCCESS)
            HSTMT               03531D58
            UWORD                        1
            SWORD                        1 <SQL_PARAM_INPUT>
            SWORD                       11 <SQL_C_TIMESTAMP>
            SWORD                       11 <SQL_TIMESTAMP>
            SQLULEN                   19
            SWORD                        0
            PTR                0x0135B5F8
            SQLLEN                     0
            SQLLEN *            0x00000000

crw32           870-8b0      ENTER SQLBindParameter
            HSTMT               03531D58
            UWORD                        2
            SWORD                        1 <SQL_PARAM_INPUT>
            SWORD                       11 <SQL_C_TIMESTAMP>
            SWORD                       11 <SQL_TIMESTAMP>
            SQLULEN                   19
            SWORD                        0
            PTR                0x0135B5A8
            SQLLEN                     0
            SQLLEN *            0x00000000

crw32           870-8b0      EXIT  SQLBindParameter  with return code 0 (SQL_SUCCESS)
            HSTMT               03531D58
            UWORD                        2
            SWORD                        1 <SQL_PARAM_INPUT>
            SWORD                       11 <SQL_C_TIMESTAMP>
            SWORD                       11 <SQL_TIMESTAMP>
            SQLULEN                   19
            SWORD                        0
            PTR                0x0135B5A8
            SQLLEN                     0
            SQLLEN *            0x00000000

crw32           870-8b0      ENTER SQLBindParameter
            HSTMT               03531D58
            UWORD                        3
            SWORD                        1 <SQL_PARAM_INPUT>
            SWORD                       11 <SQL_C_TIMESTAMP>
            SWORD                       11 <SQL_TIMESTAMP>
            SQLULEN                   19
            SWORD                        0
            PTR                0x0135B610
            SQLLEN                     0
            SQLLEN *            0x00000000

crw32           870-8b0      EXIT  SQLBindParameter  with return code 0 (SQL_SUCCESS)
            HSTMT               03531D58
            UWORD                        3
            SWORD                        1 <SQL_PARAM_INPUT>
            SWORD                       11 <SQL_C_TIMESTAMP>
            SWORD                       11 <SQL_TIMESTAMP>
            SQLULEN                   19
            SWORD                        0
            PTR                0x0135B610
            SQLLEN                     0
            SQLLEN *            0x00000000

==================================
Non-Working SQL Trace:
==================================

crw32           64c-964      ENTER SQLExecDirect
            HSTMT               037B2770
            UCHAR *             0x01232EA0 [      -3] "SELECT (FIELDS) WHERE PROBLEMS."PROBLEM_CODE" <> 'CLOSED' OR PROBLEMS."CLOSE_DATE" >= ? AND PROBLEMS."CLOSE_DATE" <= ? AND PROBLEMS."CLOSE_TIME" < '06:30:00' OR PROBLEMS."CLOSE_DATE" >= ? AND PROBLEMS."CLOSE_DATE" <= ? AND PROBLEMS."CLOSE_TIME" > '06:30:00') "            SDWORD                    -3

crw32           64c-964      EXIT  SQLExecDirect  with return code -1 (SQL_ERROR)
            HSTMT               037B2770
            UCHAR *             0x01232EA0 [      -3] "SELECT (FIELDS) WHERE ETC AND PROBLEMS."PROBLEM_CODE" <> 'CLOSED' OR PROBLEMS."CLOSE_DATE" >= ? AND PROBLEMS."CLOSE_DATE" <= ? AND PROBLEMS."CLOSE_TIME" < '06:30:00' OR PROBLEMS."CLOSE_DATE" >= ? AND PROBLEMS."CLOSE_DATE" <= ? AND PROBLEMS."CLOSE_TIME" > '06:30:00') "            SDWORD                    -3

            DIAG [07001] [Oracle][ODBC][Ora]ORA-01008: not all variables bound
 (1008)

crw32           64c-964      ENTER SQLErrorW
            HENV                037B1788
            HDBC                037B1830
            HSTMT               037B2770
            WCHAR *             0x0012C3BC (NYI)
             SDWORD *            0x0012C4FC
            WCHAR *             0x0012BFBC
            SWORD                      242
            SWORD *             0x0012C4F8

crw32           64c-964      EXIT  SQLErrorW  with return code 0 (SQL_SUCCESS)
            HENV                037B1788
            HDBC                037B1830
            HSTMT               037B2770
            WCHAR *             0x0012C3BC (NYI)
             SDWORD *            0x0012C4FC (1008)
            WCHAR *             0x0012BFBC [      54] "[Oracle][ODBC][Ora]ORA-01008: not all variables bound\ a"
            SWORD                      242
            SWORD *             0x0012C4F8 (54)
UPRRDevelopersAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
Are you running in the Crystal designer or an application?

If an application did you update the application to use the CR8.5 references?

mlmcc
0
UPRRDevelopersAuthor Commented:
Two PCs, one running Crystal Reports 8.0 and the other running Crystal Reports 8.5.  No application being used.  I open the report and refresh.  I log in with my ODBC parameters, and the one that works displays the data.  The one that doesn't promptly displays the errors.  Same report at the same location.
0
mlmccCommented:
I don't know.  As far as I know there were no real changes to Crystal between 8 and 8.5 except to add the ability to export to PDF.

Have you tried the VERIFY DATABASE under the DATABASE menu?

mlmcc
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

UPRRDevelopersAuthor Commented:
Tried 'Verify Database' just now, same error.  Thanks though.
0
mlmccCommented:
Are you not providing a value for the parameter?

mlmcc
0
UPRRDevelopersAuthor Commented:
That's the weird part.  Apparently I'm not, because there is nowhere in the original report that sets the parameter (thus the error message on the 8.5 version, I assume).  There are two parameter values that were created for that purpose, but I'm never prompted for them because they aren't part of the formula.  It appears they were built directly into the SQL (as indicated by the question marks in the SQL string above).  But I can't for the life of me figure out how its working at all on the 8.0 version.  And it's consistent -- it always works on 8.0 and has never worked on 8.5.  Maybe this is one of those mysteries that will never be solved.
0
mlmccCommented:
Try using F5 and selecting new parameter values.

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
UPRRDevelopersAuthor Commented:
When I press F5 in v8.5 and the report attempts to update, the error is produced.  I imagine the reason is that the actual SQL is the only place where the "?" parameters exist.  The fields that need the values to be provided don't show in the Select Expert, which means I'll never be prompted for them, thus the error.  I could probably add them to the Select Expert as parameter values to force them to be provided, but that brings me back to the original question, which is why does the 8.0 report work without me having to provide them?
0
UPRRDevelopersAuthor Commented:
I wrote another report that used actual values in the SQL instead of parameter values.  It's working now.  I have no idea what is allowing the report to work in 8.0, but the new report works fine in its place.  Thanks for the suggestions.
0
mlmccCommented:
I don't know.  I assume you are running the same copy of the report both places.

mlmcc
0
UPRRDevelopersAuthor Commented:
Yes, it's the same exact report from a shared drive.  That's the part that's so confusing.
0
mlmccCommented:
Just making sure it wasn't a difference in report files.

No good idea.

mlmcc
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.