cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

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

0 Likes
View Entire Topic
Former Member
0 Likes


Sorry but i am not getting. In webi the report works perfectly! the issue in on Analysis for excel not webi.

Former Member
0 Likes

that function module BICS_CONS_CREATE_DATA_AREA is used for planning cababilities. As AfO is a planning tool it tries to find the module, just in case the user needs the functionality. WebI has no planning cababilities, so WebI does not need to look for it.

Former Member
0 Likes

Hi Thorsten,

The report has no planning data...

The error is related to the 0NAME.

Any other idea on how to solve this?

Former Member
0 Likes

I just saw your log file, why you guess its 0NAME?

Former Member
0 Likes

If you check the very first image i have put in my first message, is clearly stated,

Regards

Vivian

former_member210191
Participant
0 Likes

Hi Vivian.

I face the same issue when opening a BEx query from AO. Did you find a solution for the BICS_CONS_CREATE_DATA_AREA not found dump?

This FM does not exist in my BW system.

Best regards,

Nacho

former_member210191
Participant
0 Likes

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

0 Likes

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)

TammyPowlas
SAP Mentor
SAP Mentor
0 Likes

Hello Thierry - this would be something I would send to SAP Support and open an incident.

former_member210191
Participant
0 Likes

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

0 Likes

Hi Nacho,

Thanks for your help, i try your solution but the problem still the same.

The problem is : I download a Analysis file  (ok) but when i try to refresh it (after close Analysis) i have got the issue.

Regards,

Thierry