Hi all,
I am getting the below error when running an Analysis for Excel report.
The odd thing is that the report gives the error ONLY for some specific selections, otherwise is working properly.
Moreover same version of the report in WEBI is working fine.
Someone has any clue about the issue?
Thanks
Regards
Request clarification before answering.
Sorry but i am not getting. In webi the report works perfectly! the issue in on Analysis for excel not webi.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi all,
I fixed this by uninstalling AO from my computer.
Then I deleted folder in C:\Users\<your_user>\AppData\Roaming\SAP AG\SAP BusinessObjects Advanced Analysis.
I reinstalled again.
It seems something related with the AO cache when you connect to different systems.
I hope this information is helful.
Best regards,
Nacho
Hello,
I have the same issue, i try the Ignacio solution but it's not good for me.
I put the log file
Please help !
**** Log file opened by process 15540 at 2015-02-03 16:53:08 (UTC+01:00 Paris, Madrid)
SAP .NET Connector 3.0 with file version 3.0.14.0 running on 32-bit .NET Framework 2.0.50727.5485
Program: C:\Program Files\Microsoft Office\Office14\EXCEL.EXE
Working directory: C:\Users\tchiret\Documents
Operating system: Windows 7 Professional 32-bit Service Pack 1
Processor: 4x Intel x86
SAP release: 721, Kernel release: 721, Kernel patch level: 327
Hostname: PUB12027, IP address: 10.229.10.27, IP_v6 address:
Default trace level: None
>> Info entry 2015-02-03 16:53:08.245 [Thread 1]
Trace directory changed from .\ to C:\Temp\
**** Log file opened by process 15540 at 2015-02-03 16:53:08 (UTC+01:00 Paris, Madrid)
SAP .NET Connector 3.0 with file version 3.0.14.0 running on 32-bit .NET Framework 2.0.50727.5485
Program: C:\Program Files\Microsoft Office\Office14\EXCEL.EXE
Working directory: C:\Users\tchiret\Documents
Operating system: Windows 7 Professional 32-bit Service Pack 1
Processor: 4x Intel x86
SAP release: 721, Kernel release: 721, Kernel patch level: 327
Hostname: PUB12027, IP address: 10.229.10.27, IP_v6 address:
Default trace level: None
>> Info entry 2015-02-03 16:53:08.248 [Thread 1]
Trace directory changed from .\ to C:\Temp\
>> Error entry 2015-02-03 16:53:08.898 [Thread 1]
[NAME=BOE_DS_CP2 SYSID=CP2 CLIENT=001 MYSAPSSO2=******** LANG=FR SYSNR=01 ASHOST=sapprdbw.resdom.amaury.local CODEPAGE=1100 IDLE_TIMEOUT=60 REP_CONN_IDLE_TIMEOUT=86400 IDLE_CHECK_TIME=15 POOL_SIZE=2 MAX_POOL_SIZE=9999 PASSWORD_CHANGE_ENFORCED=true]
SAP.Middleware.Connector.RfcInvalidStateException: Lookup of function BICS_CONS_CREATE_DATA_AREA metadata failed for destination BOE_DS_CP2 ---> SAP.Middleware.Connector.RfcAbapException: FU_NOT_FOUND
à SAP.Middleware.Connector.RfcConnection.ThrowRfcErrorMsg()
à SAP.Middleware.Connector.RfcConnection.RfcReceive(RfcFunction function)
à SAP.Middleware.Connector.RfcFunction.RfcDeserialize(RfcConnection conn, IRfcIOStream stream)
à SAP.Middleware.Connector.RfcFunction.RfcCallReceive(RfcConnection conn, IRfcIOStream stream, RFCID rid)
à SAP.Middleware.Connector.RfcRepository.Execute(RfcFunction function)
à SAP.Middleware.Connector.RfcRepository.LookupFunctionMetadataClassic(String name)
--- Fin de la trace de la pile d'exception interne ---
à SAP.Middleware.Connector.RfcRepository.LookupFunctionMetadataClassic(String name)
à SAP.Middleware.Connector.RfcRepository.LookupFunctionMetadata(String name)
à SAP.Middleware.Connector.RfcRepository.GetFunctionMetadata(String name)
>> Error entry 2015-02-03 16:53:08.900 [Thread 1]
SAP.Middleware.Connector.RfcInvalidStateException: Lookup of function BICS_CONS_CREATE_DATA_AREA metadata failed for destination BOE_DS_CP2 ---> SAP.Middleware.Connector.RfcAbapException: FU_NOT_FOUND
à SAP.Middleware.Connector.RfcConnection.ThrowRfcErrorMsg()
à SAP.Middleware.Connector.RfcConnection.RfcReceive(RfcFunction function)
à SAP.Middleware.Connector.RfcFunction.RfcDeserialize(RfcConnection conn, IRfcIOStream stream)
à SAP.Middleware.Connector.RfcFunction.RfcCallReceive(RfcConnection conn, IRfcIOStream stream, RFCID rid)
à SAP.Middleware.Connector.RfcRepository.Execute(RfcFunction function)
à SAP.Middleware.Connector.RfcRepository.LookupFunctionMetadataClassic(String name)
--- Fin de la trace de la pile d'exception interne ---
à SAP.Middleware.Connector.RfcRepository.LookupFunctionMetadataClassic(String name)
à SAP.Middleware.Connector.RfcRepository.LookupFunctionMetadata(String name)
à SAP.Middleware.Connector.RfcRepository.GetFunctionMetadata(String name)
à SAP.Middleware.Connector.RfcRepository.CreateFunction(String name)
>> Error entry 2015-02-03 16:53:12.927 [Thread 1]
[NAME=BOE_DS_CP2 SYSID=CP2 CLIENT=001 MYSAPSSO2=******** LANG=FR SYSNR=01 ASHOST=sapprdbw.resdom.amaury.local CODEPAGE=1100 IDLE_TIMEOUT=60 REP_CONN_IDLE_TIMEOUT=86400 IDLE_CHECK_TIME=15 POOL_SIZE=2 MAX_POOL_SIZE=9999 PASSWORD_CHANGE_ENFORCED=true]
SAP.Middleware.Connector.RfcAbapMessageException: Valeur "0" de la caractéristique ZMIND_IO1 non convertie en ALPHA
à SAP.Middleware.Connector.RfcConnection.ThrowRfcErrorMsg()
à SAP.Middleware.Connector.RfcConnection.ReadBytes(Byte* buffer, Int32 count)
à SAP.Middleware.Connector.RfcConnection.ReadRfcIDBegin(Int32& length)
à SAP.Middleware.Connector.RfcConnection.ReadUpTo(RFCGET readState, RfcFunction function, RFCID toRid)
à SAP.Middleware.Connector.RfcConnection.RfcReceive(RfcFunction function)
à SAP.Middleware.Connector.RfcFunction.RfcDeserialize(RfcConnection conn, IRfcIOStream stream)
à SAP.Middleware.Connector.RfcFunction.RfcCallReceive(RfcConnection conn, IRfcIOStream stream, RFCID rid)
à SAP.Middleware.Connector.RfcFunction.RfcCallReceive(RfcConnection conn)
à SAP.Middleware.Connector.RfcFunction.Invoke(RfcDestination destination)
>> Error entry 2015-02-03 16:53:13.031 [Thread 1]
[NAME=BOE_DS_CP2 SYSID=CP2 CLIENT=001 MYSAPSSO2=******** LANG=FR SYSNR=01 ASHOST=sapprdbw.resdom.amaury.local CODEPAGE=1100 IDLE_TIMEOUT=60 REP_CONN_IDLE_TIMEOUT=86400 IDLE_CHECK_TIME=15 POOL_SIZE=2 MAX_POOL_SIZE=9999 PASSWORD_CHANGE_ENFORCED=true]
SAP.Middleware.Connector.RfcAbapException: INVALID_DATA_PROVIDER_HANDLE
à SAP.Middleware.Connector.RfcConnection.ThrowRfcErrorMsg()
à SAP.Middleware.Connector.RfcConnection.RfcReceive(RfcFunction function)
à SAP.Middleware.Connector.RfcFunction.RfcDeserialize(RfcConnection conn, IRfcIOStream stream)
à SAP.Middleware.Connector.RfcFunction.RfcCallReceive(RfcConnection conn, IRfcIOStream stream, RFCID rid)
à SAP.Middleware.Connector.RfcFunction.RfcCallReceive(RfcConnection conn)
à SAP.Middleware.Connector.RfcFunction.Invoke(RfcDestination destination)
>> Error entry 2015-02-03 16:53:17.904 [Thread 1]
[NAME=BOE_DS_CP2 SYSID=CP2 CLIENT=001 MYSAPSSO2=******** LANG=FR SYSNR=01 ASHOST=sapprdbw.resdom.amaury.local CODEPAGE=1100 IDLE_TIMEOUT=60 REP_CONN_IDLE_TIMEOUT=86400 IDLE_CHECK_TIME=15 POOL_SIZE=2 MAX_POOL_SIZE=9999 PASSWORD_CHANGE_ENFORCED=true]
SAP.Middleware.Connector.RfcAbapException: INVALID_DATA_PROVIDER_HANDLE
à SAP.Middleware.Connector.RfcConnection.ThrowRfcErrorMsg()
à SAP.Middleware.Connector.RfcConnection.RfcReceive(RfcFunction function)
à SAP.Middleware.Connector.RfcFunction.RfcDeserialize(RfcConnection conn, IRfcIOStream stream)
à SAP.Middleware.Connector.RfcFunction.RfcCallReceive(RfcConnection conn, IRfcIOStream stream, RFCID rid)
à SAP.Middleware.Connector.RfcFunction.RfcCallReceive(RfcConnection conn)
à SAP.Middleware.Connector.RfcFunction.Invoke(RfcDestination destination)
Hi Thierry.
Delete all contents in folder:
C:\Users\<your_user>\AppData\Roaming\SAP AG\SAP BusinessObjects Advanced Analysis\cache
You should find there a file with your system ID, something like CP2.cache. Delete this file and restart AO. I realized you do not have to uninstall the application.
I hope this information helps you.
Best regards,
Nacho
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.