Results 1 to 8 of 8
  1. #1
    Join Date
    Sep 2003
    Posts
    4

    Unanswered: Internal Query Processor Error: Please Help!!!!!!!

    Hi Guys!

    I got this problem running my stored procedure in PB8. An error message "Internal Query Processor Error: The query processor encountered an unexpected error during execution." appears.

    I had surfed the net to find out the cause of the error and found out that the error is a bug in SQL 7 with Service Pack 2. However, my program/stored procedure perfectly runs using my local connection in my PC with Service Pack 2. The error only occurs when my program is run and is connected to the server. But the server is using Service Pack 3. Furthermore, my stored procedure executes perfectly in my Query Analyzer regardless of where it is connected, be in my local db or in the server.

    Please help me... am so confused!

    Thanks a lot!

    lovella

  2. #2
    Join Date
    Sep 2003
    Posts
    522
    post the query

  3. #3
    Join Date
    Sep 2003
    Posts
    522
    post the query

  4. #4
    Join Date
    Sep 2003
    Posts
    4

    Smile

    Hi ms_sql_dba!

    Thanks for your prompt reply.

    Actually its a real lengthy stored procedure and I wanna know if you are interested and have the luxury of time to go over it.

    Thanks again!

  5. #5
    Join Date
    Sep 2003
    Posts
    522
    don't really have the luxury, but someone else may.

  6. #6
    Join Date
    Sep 2003
    Posts
    522
    don't really have the luxury, but someone else may.

  7. #7
    Join Date
    Sep 2003
    Posts
    4
    This is the portion that triggers the error coz when excluded in the execution no error is encountered.

    Update t_tmc_dtl
    set amount = num_basis /
    ( Select sum(num_basis)
    From t_tmc_dtl xx
    inner join #pl_ucode zz on zz.user_code =
    xx.td_user_code
    Where xx.class_type = t_tmc_dtl.class_type
    and xx.user_code = t_tmc_dtl.user_code
    and zz.ref_usercode = #pl_ucode.ref_usercode
    and zz.prod_type = #pl_ucode.prod_type
    Group by zz.ref_usercode, zz.prod_type ) * @amount
    From t_tmc_dtl
    inner join #pl_ucode on #pl_ucode.user_code = t_tmc_dtl.td_user_code
    Where t_tmc_dtl.class_type = @c_type
    and t_tmc_dtl.user_code = @u_code

  8. #8
    Join Date
    Sep 2003
    Posts
    4
    by the way.... #pl_ucode is an implicit temporary table (created by the SELECT.... INTO clause )

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •