[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] Cannot run the program using SQRW
I got the first error (character string buffer too small) trying to run SQR
6.2 against Oracle 9.2. What versions of SQRw and Oracle are you using?
-----Original Message-----
From: yelena_kontorovich@baxter.com
[mailto:yelena_kontorovich@baxter.com]
Sent: Thursday, December 04, 2003 9:44 AM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] Cannot run the program using SQRW
Sorry, I've got sidetracked, but my problem still exists. I've done more
research and this is what I found:
1. When I run this program using SQRW against production database I get
the following:
***** BX-STD-ERROR *****
INSERT_DEMOCHG_T failed on SQL Insert for key=114042
SQL status=-1.000000 SQL error text: ORA-00604: error occurred at
recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too
small
ORA-06512: at line 8
ORA-00001: unique constraint (SYSADM.PS_BPY_DEMOCHG_T) violated
Program stopped on previous error.
2. When I run the same program on a database server I get:
SQL note: SQL failed on duplicate insert, but set to continue; KEY=
114042
asoftoday: 04-DEC-2003/
emplid : 114042/
effdt: : 2000-05-01/
SQL note: SQL failed on duplicate insert, but set to continue; KEY=
114042
3. When I run this program using SQRW against any other database I get:
SQL note: SQL failed on duplicate insert, but set to continue; KEY=
114042
asoftoday: 04-DEC-2003/
emplid : 114042/
effdt: : 2000-05-01/
SQL note: SQL failed on duplicate insert, but set to continue; KEY=
114042
4. When I have ANY errors using SQRW agains production database (incorrect
password and so on), I get the message
ORA-06502: PL/SQL: numeric or value error: character string buffer too
small
ORA-06512: at line 8
5. Program has a logic to look for duplicates.
begin-procedure INSERT-BPY-DEMOCHG-T
let $key = $job.emplid
!insert a row to indicate a dealcode change
begin-SQL ON-ERROR=BX-STD-ERROR('INSERT_DEMOCHG_T','SQLI',$key,'Y','Y')
!expect a few dups on insert
insert into PS_BPY_DEMOCHG_T
(EMPLID,
POSITION_NBR,
ACTION_CD,
TRANS_DT,
BX_TRANS_TIME,
BX_MISC_DATA)
Values
($job.emplid,
' ',
'GRP',
$job.effdt,
SYSDATE,
$dtu_job.effdt )
end-SQL
add #sql-count to #demo_grp_inserts
!check for retro changes - if so, add another demochg record so it gets
picked up
show 'asoftoday: ' $ASOFTODAY '/'
show 'emplid : ' $job.emplid '/'
show 'effdt: : ' $dtu_job.effdt '/'
if $DTU_job.effdt < $DTU_asoftoday
begin-SQL ON-ERROR=BX-STD-ERROR('INSERT_DEMOCHG_T3','SQLI',$key,'Y','Y')
!expect a few duplicates
insert into PS_BPY_DEMOCHG_T
(EMPLID,
POSITION_NBR,
ACTION_CD,
TRANS_DT,
BX_TRANS_TIME,
BX_MISC_DATA)
Values
($job.emplid,
' ',
'GRP',
$job.effdt,
SYSDATE,
$dtu_job.effdt )
end-SQL
add #sql-count to #demo_rtr_inserts
end-if
end-procedure INSERT-BPY-DEMOCHG-T
6. This is my sqrw parms:
(Embedded image moved to file: pic23856.pcx)
I think it is some setup somewhere, but I have to idea where to look.
Please HELP !
Thanks,
Yelena Kontorovich
Technical Consultant
847.948.2927
yelena_kontorovich@baxter.com
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, re-transmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the content.
"Genady
Sosnovsky" To: sqr-users@sqrug.org
<genadys@ontko. cc:
com> Subject: Re: [sqr-users]
Cannot
run the program using SQRW
Sent by:
sqr-users-admin
@sqrug.org
11/26/2003
02:57 PM
Please respond
to sqr-users
Yelena,
Please give us a bit more information about what your SQR code exactly
does.
Preliminary, it seems that it is trying to execute a pl/sql code with one
of
the following command: delete, update, insert. It is not necessary it's in
your main sqr program module, it could be in an included file, it could be
an auxiliary routine that your report invokes ( logging or etc.) Check with
your DBA, maybe that particular database table access privileges are not
granted to the user you are using to run your report.
Genady,
genadys@ontko.com
> Hello, everyone,
> I'm trying to run my program using SQRW and I keep receiving the
following
> message:
>
> SQL status=-1.000000 SQL error text: ORA-00604: error occurred at
> recursive SQL level 1
> ORA-06502: PL/SQL: numeric or value error: character string buffer too
> small
> ORA-06512: at line 8
> ORA-00001: unique constraint (SYSADM.PS_BPY_DEMOCHG_T) violated
> Program stopped on previous error.
>
> Program has a logic to ignore duplicate errors. I don't think it is
data -
> I think it is the setup, but I don't know where to look.
>
> My reasons to think that I have a setup issue are:
> 1. This error happens in 1 database only. In different database (the
same
> data, we keep it for reporting) my programs runs normally.
>
> 2. When I simulated login error (typed wrong password) - I've received
the
> following:
>
> (SQR 5528) ORACLE OCISessionBegin(RDBMS) error 604 in cursor 0:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-06502: PL/SQL: numeric or value error: character string buffer too
> small
> ORA-06512: at line 8
> ORA-01017: invalid username/password; logon denied
> (SQR 4701) Cannot logon to the database.
>
> SO I think my error handling is screwed up somewhere. Do you have any
> ideas?
>
> Thanks,
> Yelena Kontorovich
> Technical Consultant
> 847.948.2927
> yelena_kontorovich@baxter.com
> The information transmitted is intended only for the person or entity to
> which it is addressed and may contain confidential and/or privileged
> material. Any review, re-transmission, dissemination or other use of, or
> taking of any action in reliance upon, this information by persons or
> entities other than the intended recipient is prohibited. If you
received
> this in error, please contact the sender and delete the content.
>
>
>
--------------------------------------------------------------------------
----
> The information transmitted is intended only for the person(s)or entity
to
> which it is addressed and may contain confidential and/or legally
privileged
> material. Delivery of this message to any person other than the intended
> recipient(s) is not intended in any way to waive privilege or
confidentiality.
> Any review, retransmission, dissemination or other use of , or taking of
any
> action in reliance upon, this information by entities other than the
intended
> recipient is prohibited. If you receive this in error, please contact
the
> sender and delete the material from any computer.
>
> For Translation:
>
> http://www.baxter.com/email_disclaimer
>
============================================================================
==
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
>
>
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
----------------------------------------------------------------------------
--
The information transmitted is intended only for the person(s)or entity to
which it is addressed and may contain confidential and/or legally privileged
material. Delivery of this message to any person other than the intended
recipient(s) is not intended in any way to waive privilege or
confidentiality.
Any review, retransmission, dissemination or other use of , or taking of any
action in reliance upon, this information by entities other than the
intended
recipient is prohibited. If you receive this in error, please contact the
sender and delete the material from any computer.
For Translation:
http://www.baxter.com/email_disclaimer
============================================================================
==
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users