ORA-01760: illegal argument for function

[Former Member]

Hi Experts ,

Let me know if anyone can provide solution to  the below dump.

DBMS_STATS: GATHER_STATS_JOB encountered errors.  Check the trace file.

Errors in file /oracle/XXX/saptrace/diag/rdbms/xxx/XXX/trace/XYZ_j000_21782.trc:

ORA-01760: illegal argument for function

Further ,trace file says as below::

Trace file /oracle/XXX/saptrace/diag/rdbms/XXX/XXX/trace/XXX_j000_21782.trc

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORACLE_HOME = /oracle/XYZ/112_64

System name:    Linux

Node name:      secc3350

Release:        2.6.32-279.19.1.el6.x86_64

Version:        #1 SMP Sat Nov 24 14:35:28 EST 2012

Machine:        x86_64

VM name:        VMWare Version: 6

Instance name: ZZZ

Redo thread mounted by this instance: 1

Oracle process number: 126

Unix process pid: 21782,

*** 2013-12-29 06:01:53.249

*** SESSION ID:(65.30561) 2013-12-29 06:01:53.249

*** CLIENT ID:() 2013-12-29 06:01:53.249

*** SERVICE NAME:(SYS$USERS) 2013-12-29 06:01:53.249

*** MODULE NAME:(DBMS_SCHEDULER) 2013-12-29 06:01:53.249

*** ACTION NAME:(ORA$AT_OS_OPT_SY_2631) 2013-12-29 06:01:53.249

ORA-01760: illegal argument for function

*** 2013-12-29 06:01:53.333

DBMS_STATS: GATHER_STATS_JOB: GATHER_TABLE_STATS('"SAPSR3"','"/BIC/FRFIC03"','""', ...)

DBMS_STATS: ORA-01760: illegal argument for function

Regards

Ram

[Reagan]

Try setting the below parameter to false and see if that helps.

alter session set query_rewrite_enabled=false;

Saw a recommendation from Oracle suggesting the same.

Regards

RB

[former_member45419]

Hi Bharatram,

pls check this link ,

ORA-12012: error on auto execute of job | Oracle Forums

Regards

Nayeem

[Former Member]

Hi Khaja,

I have seen that earlier and below is the output of that ::

SQL> select job_name,status,error# from DBA_SCHEDULER_JOB_RUN_DETAILS where job_name='AUTO_SPACE_ADVISOR_JOB';

no rows selected

Regards

Ram

[former_member45419]

Hi Bharatram,

pls refr this link,

http://oracle.ittoolbox.com/groups/technical-functional/oracle-dev-l/dbms_statsgather_table_statsis-...

Regards

Nayeem

[karthikeyan_natarajan4]

Hi Bharatram,

Please check this note

http://service.sap.com/sap/support/notes/974781

1615380 - Mini Checks

618868 - FAQ: Oracle performance

GATHER_STATS_JOB are deactivated by default, are you getting this issue in brtools.

regards

kartik

[Former Member]

Hi Karthik,

Yes am getting this issue in brtools and the errror we obtain in the alert logs and trace file .

Let me know if anything is required from my end further

Regards

Ram

[Former Member]

Hi Bharat

Are you getting this error when you are running gather statistics from DB13 calendar ?

Also is this coming for this specific table or other tables are running fine

Thanks

Rishi

[Former Member]

Hi Rishi,

Am getting this error when brtools is schduling update stats via crontab and not via DB13

Further this error comes as below  ::

DBMS_STATS: GATHER_STATS_JOB: GATHER_TABLE_STATS('"SAPSR3"','"/BIC/FRFIC03"','""', ...)

I cannot say if it is a table or many tables

Let me know your workarounds

Regards

Ram

[former_member185239]

Hi Rama,

1. Logon to sqlplus with sapsr3 user

   sqlplus /nolog

   connect SAPSR3/<password

2. Execute the below command

exec dbms_stats.gather_table_stats('SAPSR3', '/BIC/FRFIC03');

Also paste the BR logs

With Regards

Ashutosh Chaturvedi

[Former Member]

Can you attach log file for brconnect execution?

[Former Member]

Thanks ashutosh !!!

Am not aware of SAPSR3 password and dont want to take a risk

Am aware of pasword changing mechansim too

Regards

Ram

[Former Member]

Hi Roman

I could not see in the brconnect logs ,But could visible see in the alert logs and trace file

Regards

Ram

[Sriram2009]

Hi Ram

Could you check this SCN link

http://scn.sap.com/thread/1756508

Regards

Ram

[Former Member]

Hi Sriram,

above link is not helping me .

Am having Brtools version (7.20 patch 30)

oraxxx> brtools

BR0651I BRTOOLS 7.20 (30)

Regards

Ram

[karthikeyan_natarajan4]

Hi Bharatram,

please paste the alert_log information too.

regards

kartik

[Former Member]

Hi Karthik,

I got the error firstly in alert logs and that log redirected to trace file.

Further i don't have sufficient information in alert log and that is  y i have pasted the trace file

Regards

Ram