RE: [sqr-users] <SQR 5730> error while executing

[premnath sunkara <spn1981@yahoo.com>]

Hi Steve,
    Thanks for your time. 
> Whenever you run SQR, any display or show messages
> will be written to a
> file.  You can specify the name of the file on the
> SQR command line, but if
> you don't specify it, it will be called "sqr.log"
> and be written to your
> current working directory.  

ans)Yes, that's happening with all my other SQR
programs but this one is an exception.


Are you running this
> program from Peoplesoft or
> from your PC?  That would determine was is your
> current working directory.

ans)I am running the program from my PC.

> Maybe you don't have the system rights to create a
> file in that directory.

ans)I have the rights to create a file in that
directory. I created that directory. Also i 
am able to run other SQR programs in that directory.


> Perhaps you've already created a file called sqr.log
> and it is read-only, or
> you might have it open in an editor.  Any of those
> cases would stop SQR from
> opening (creating) it again.

ans)I also tried executing the program after deleting
sqr.log file. I also checked it for 
read-only issue. And it is not opened in any editor.

I dont know why this program alone is acting weirdly
and i cant find any errors in the program also.

Thanks,
Premnath Sunkara.






> 
> -----Original Message-----
> From: premnath sunkara [mailto:spn1981@yahoo.com]
> Sent: Friday, October 24, 2003 10:34 AM
> To: sqr-users@sqrug.org
> Subject: [sqr-users] <SQR 5730> error while
> executing
> 
> 
> Hi,
>        I am trying to run the following program.
> This
> program reads from a flat file and inserts the data
> in
> the flat file into a record. It is giving me the
> following error 
> <SQR 5703> Error opening the SQR log file: 'sqr.log'
>  
> <13>: Permission denied
> 
> these are the configurations i am using
> 
> Brio product and version number :
> SQR/4.3.4/PC/Windows NT 4.0/Oracle 7.3.4/Jun 03 1999
> 
> Operating system and version number:
> Windows2000 5.00.2195
> Database name and version number:
> Oracle
> Application name: PeopleSoft 8.42
>  
> This is happening only for this program. All my
> other
> programs are fine. The input file is in the
> following
> format
> 
> 34, 34, 34, 34
> 34, 34, 34, 34
> 34, 34, 34, 34
> 
> The record in the database is also fine. I mean it
> has
> all the fields i gave in the program in the same
> order.
> The program is given below:
> 
> 
> !testing  program
> !using flat files to populate database
> 
> begin-program
> 
>         open 'C:\Documents and
> Settings\psunkara\Desktop\test.txt' as 1 for-reading
> record 3000
>                 !status=#filestat
> !       if #filestat !0
> !               show 'error opening input file'
> !       else
>                 do read_input_file
> !       end-if
> 
> end-program
> 
> begin-procedure read_input_file
> 
>         display 'inseritng records from file
> C:\Documents and
> Settings\psunkara\Desktop\test.txt into
> UHS_PORTINVCODE'
>         move 0 to #inserts
>         move 0 to #tot-recs
> 
>         while not #end-file
>                 read 1 into $input:1000
>                 if #end-file 
>                         break
>                 end-if
>                 unstring $input by $sepchar into -
>                 $UHS_NDIP -
>                 $UHS_NDNAME -
>                 $UHS_PORT -
>                 $UHS_DELTATRAFFIC
>         
>                 do insert_temp_job
>         end-while
> 
>         close 1
> !       display 'total records inserted: ' noline
> !       display #tot_recs 999,999,999
> 
> end-procedure
> 
> begin-procedure insert_temp_job
> 
> begin-sql on-error=insert_error
> 
>         insert into PS_UHS_PORTINVCODE
>         (
>         UHS_NDIP,
>         UHS_NDNAME,
>         UHS_PORT,
>         UHS_DELTATRAFFIC
>         )
> 
>         values
>         (
>         $UHS_NDIP,
>         $UHS_NDNAME,
>         $UHS_PORT,
>         $UHS_DELTATRAFFIC
>         )
>         
>         end-sql
> !       if #sql-count=1
> !               add 1 to #inserts
> !               if #inserts >= 500
>                         commit
> !                       move 0 to #inserts
> !               end-if
> !               add 1 to #tot_recs
> !       end-if
> 
> end-procedure
> 
> begin-procedure insert_error
>         
>         if #sql-status=-9 !if duplicate(this code is
> for
> oracle only)
>                 show 'insert error:duplicate role is
> not allowed for
> NDIP' $UHS_NDIP
>         else
>                 show 'insert error: ' $sql-error
>                 show 'error number: ' #sql-status
>                 stop !halt program and rollback
>         end-if
> 
> end-procedure
> 
> Thanking you in advance,
> Regards,
> Premnath Sunkara.
> 
> 
> 
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product
> search
> http://shopping.yahoo.com
> 
> _______________________________________________
> 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


__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users