使用BODS从多个Excel文件中提取数据

2020-08-21 12:59发布

点击此处---> 群内免费提供SAP练习系统(在群公告中)加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)大家好, 我正在尝试通配符搜索...

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


大家好,

我正在尝试通配符搜索以从共享文件夹位置读取多个Excel文件,但出现以下错误。 欣赏你的想法。

1575216028SYS-17010127/03/2018 09:15:20 |会话GCS_JOB_MULTIFILE_READ |数据流DF_File_Test 1575216028SYS-17010127/03/2018 09:15:20系统异常发生。 进程转储选项已关闭。 进程未转储。 1575216028SYS-17010127/03/2018 09:15:20调用堆栈:1575216028SYS-17010127/03/2018 09:15:200x00000000A27C137D,Ordinal2334()+ 100437字节1575216028SYS-17010127/03/2018 09:15:200x00000000AF88C710,_C_specific_handler ()+0544字节1575216028SYS-17010127/03/2018 09:15:200x00000000AF882AC2,_FrameUnwindFilter()+ 1074字节1575216028SYS-17010127/03/2018 09:15:200x00000000C3942B03,RtlCaptureContext()+ 0963字节( s)1575216028SYS-17010127/03/2018 09:15:200x00000000A2563C0B,Ordinal1377()+ 0155字节1575216028SYS-17010127/03/2018 09:15:200x00000000A2556372,Ordinal2326()+ 20770字节1575216028SYS-17010127/03/2018 09:15:200x00000000A1846283,Ordinal88()+ 0027字节1575216028SYS-17010127/03/2018 09:15:200x00000000A(字节)Ordinal4303()+ 0939字节1575216028SYS-17010127/03/2018 09:15 :200x00000000A002E141,Ordinal3689()+ 0049字节1575216028SYS-17010127/03/2018 09:15:200x000000009FDD2D29 1575216028SYS-17010127/03/2018 09:15:200x000000009FDD2C32 1575216028SYS-17010127/03/2018 09:15: 200x00000000AF7C31E8,DllGetClassObject()+ 2440字节1575216028SYS-17010127/03/2018 09:15:200x00000000AF7C3123,DllGetClassObject()+ 2243字节1575216028SYS-17010127/03/2018 09:15:200x00000000A386D577,DllMain()+ 13479字节1575216028SYS-17010127/03/2018 09:15:200x00000000A386D656,DllMain()+ 13702字节1575216028SYS-17010127/03/2018 09:15:200x00000000A389FAAF,DllCanUnloadNow()+ 39055字节1575216028SYS -17010127/03/2018 09:15:200x00000000A4181455,DllGetClassObject()+ 14149字节1575216028SYS-17010127/03/2018 09:15:200x00000000A418127C,DllGetClassObject()+ 13676字节1575216028SYS-17010127/03/2018 09:15:200x00000000A417ECEA,DllGetClassObject()+ 4058字节1575216028SYS-17010127/03/2018 09:15:200x00000000815DA2C8,ADODB :: Connection15 :: Open()+ 0120字节,1575216028SYS-17010127/03/2018 09:15:20d:\ im_ds_4.2_sp08_patch_rel \ src\ dataservices \ dataintegrator \ codeline \ code \ inc \ excel \ win64_x64 \ msado15.tli,1269 + 0068行1575216028SYS-17010127/03/2018 09:15:20byte(s )157521602 8SYS-17010127/03/2018 09:15:200x00000000815DABA3,ExcelDataObject :: open()+ 1251个字节,1575216028SYS-17010127/03/2018 09:15:20d:\ im_ds_4.2_sp08_patch_rel \ src\ dataservices \ dataintegrator \ codeline \ code \ src\ excel \ excel.cpp,行0130 + 0359字节1575216028SYS-17010127/03/2018 09:15:200x0000000080E52E0B,RdrExcel :: getnext()+ 1051字节,1575216028SYS-17010127/03/2018 09:15:20d:\ im_ds_4.2_sp08_patch_rel \ src\ dataservices \ dataintegrator \ codeline \ code \ src\ reader \ rdrexcel.cpp,2153行1575216028SYS-17010127/03/2018 09:15:200x0000000080E4E25F,RdrExcel :: execute()+ 0063字节,1575216028SYS-17010127/03/2018 09:15:20d:\ im_ds_4.2_sp08_patch_rel \ src\ dataservices \ dataintegrator \ codeline \ code \ src\ reader \ rdrexcel.cpp,第2312行1575216028SYS- 17010127/03/2018 09:15:200x00000000801CC210,XTran_desc :: execute()+ 0448字节,1575216028SYS-17010127/03/2018 09:15:20d:\ im_ds_4.2_sp08_patch_rel \ src\ dataservices \ dataintegrator \ codeline \ 代码\ src\ core \ xtran.cpp,行0812 1575216028SYS-17010127/03/2018 09:1 5:200x00000000811ACE45,Rww_thread :: main()+ 0261个字节,1575216028SYS-17010127/03/2018 09:15:20d:\ im_ds_4.2_sp08_patch_rel \ src\ dataservices \ dataintegrator \ codeline \ code \ src\ rww \ rwww .cpp,行0458 1575216028SYS-17010127/03/2018 09:15:200x0000000000A9438E,RWThreadFunctionImp :: run()+ 0126字节1575216028SYS-17010127/03/2018 09:15:200x0000000000A7C184,RWRunnableImp :: exec()+ 0372字节1575216028SYS-17010127/03/2018 09:15:200x0000000000A94643,RWThreadImp :: exec()+ 0051字节1575216028SYS-17010127/03/2018 09:15:200x0000000000A95F59,RWThreadImp :: _ setTimeSliceQuantum()+ 0169字节1575216028SYS-17010127/03/2018 09:15:200x00000000693D37D7,endthreadex()+ 0071字节1575216028SYS-17010127/03/2018 09:15:200x00000000693D3894,endthreadex()+ 0260字节1575216028SYS -17010127/03/2018 09:15:200x00000000C13413D2,BaseThreadInitThunk()+ 0034字节1575216028SYS-17010127/03/2018 09:15:200x00000000C38C54F4,RtlUserThreadStart()+ 0052字节1575216028SYS-17010127/03/2018 09:15:20寄存器:1 575216028SYS-17010127/03/2018 09:15:20RAX = 00000000A27C1370 RBX = 00000000103BDA80 RCX = 00000000A27C1370 RDX = 00000000103BDCB0 RSI = 0000000000000000 1575216028SYS-17010127/03/2018 09:15:20RDI = 00000000103BC00000000R00000000BBC00000000R00000000B = 0000000000010206 1575216028SYS-17010127/03/2018 09:15:20R8 = 0000000000000100 R9 = 0000000019930520 R10 = 00000000C38B57D0 R11 = 00000000103BB9C0 R12 = 00000000103BCA28 1575216028SYS-17010127/03/2018 09:15:20R13 = 00000000A2AEDB60 R14 = 15000000000000000000002 17010127/03/2018 09:15:20异常代码:C0000005 ACCESS_VIOLATION 1575216028SYS-17010127/03/2018 09:15:20故障地址:00007FFAA27C137D 01:000000000036037D C:\ Program Files \ Common Files \ Microsoft 1575216028SYS-17010127/03/2018 09 :15:20Shared \ Office16 \ mso40uiwin32client.dll 1575216028SYS-17010127/03/2018 09:15:20 ============================ ============================= 1575216028SYS-17010127/03/2018 09:15:20收集以下内容并发送给客户 支持:1575216028SYS-17010127/03/2018 09:15:201。 与此失败的作业关联的日志文件(error _ *,monitor _ *,trace_ *)。 1575216028SYS-17010127/03/2018 09:15:202 导出此失败作业的ATL文件。 1575216028SYS-17010127/03/2018 09:15:203。 在此失败的作业中引用的表的DDL语句。 1575216028SYS-17010127/03/2018 09:15:204。 用于填充失败作业中引用的表的数据。 如果不可能,请在1575216028SYS-17010127/03/2018 09:15:20作业失败时获取最后几行(或其中的一些示例)。 1575216028SYS-17010127/03/2018 09:15:205。 从此失败的作业生成的核心转储(如果有)。 1575216028SYS-17010127/03/2018 09:15:20 ====================================== ==================== 1575216028SYS-17010127/03/2018 09:15:20 |会话GCS_JOB_MULTIFILE_READ |数据流DF_File_Test 1575216028SYS-17010127/03/2018 09:15: 20发生系统异常。 进程转储选项已关闭。 进程未转储。 1575216028SYS-17010127/03/2018 09:15:20调用堆栈:1575216028SYS-17010127/03/2018 09:15:200x00000000A27C137D,Ordinal2334()+ 100437字节1575216028SYS-17010127/03/2018 09:15:200x00000000AF88C710,_C_specific_handler ()+0544字节1575216028SYS-17010127/03/2018 09:15:200x00000000AF882AC2,_FrameUnwindFilter()+ 1074字节1575216028SYS-17010127/03/2018 09:15:200x00000000C3942B03,RtlCaptureContext()+ 0963字节( s)1575216028SYS-17010127/03/2018 09:15:200x00000000A2563C0B,Ordinal1377()+ 0155字节1575216028SYS-17010127/03/2018 09:15:200x00000000A2556372,Ordinal2326()+ 20770字节1575216028SYS-17010127/03/2018 09:15:200x00000000A1846283,Ordinal88()+ 0027字节1575216028SYS-17010127/03/2018 09:15:200x00000000A(字节)Ordinal4303()+ 0939字节1575216028SYS-17010127/03/2018 09:15 :200x00000000A002E141,Ordinal3689()+ 0049字节1575216028SYS-17010127/03/2018 09:15:200x000000009FDD2D29 1575216028SYS-17010127/03/2018 09:15:200x000000009FDD2C32 1575216028SYS-17010127/03/2018 09:15: 200x00000000AF7C31E8,DllGetClassObject()+ 2440字节1575216028SYS-17010127/03/2018 09:15:200x00000000AF7C3123,DllGetClassObject()+ 2243字节1575216028SYS-17010127/03/2018 09:15:200x00000000A386D577,DllMain()+ 13479字节1575216028SYS-17010127/03/2018 09:15:200x00000000A386D656,DllMain()+ 13702字节1575216028SYS-17010127/03/2018 09:15:200x00000000A389FAAF,DllCanUnloadNow()+ 39055字节1575216028SYS -17010127/03/2018 09:15:200x00000000A4181455,DllGetClassObject()+ 14149字节1575216028SYS-17010127/03/2018 09:15:200x00000000A418127C,DllGetClassObject()+ 13676字节1575216028SYS-17010127/03/2018 09:15:200x00000000A417ECEA,DllGetClassObject()+ 4058字节1575216028SYS-17010127/03/2018 09:15:200x00000000815DA2C8,ADODB :: Connection15 :: Open()+ 0120字节,1575216028SYS-17010127/03/2018 09:15:20d:\ im_ds_4.2_sp08_patch_rel \ src\ dataservices \ dataintegrator \ codeline \ code \ inc \ excel \ win64_x64 \ msado15.tli,1269 + 0068行1575216028SYS-17010127/03/2018 09:15:20byte(s )157521602 8SYS-17010127/03/2018 09:15:200x00000000815DABA3,ExcelDataObject :: open()+ 1251个字节,1575216028SYS-17010127/03/2018 09:15:20d:\ im_ds_4.2_sp08_patch_rel \ src\ dataservices \ dataintegrator \ codeline \ code \ src\ excel \ excel.cpp,行0130 + 0359字节1575216028SYS-17010127/03/2018 09:15:200x0000000080E52E0B,RdrExcel :: getnext()+ 1051字节,1575216028SYS-17010127/03/2018 09:15:20d:\ im_ds_4.2_sp08_patch_rel \ src\ dataservices \ dataintegrator \ codeline \ code \ src\ reader \ rdrexcel.cpp,2153行1575216028SYS-17010127/03/2018 09:15:200x0000000080E4E25F,RdrExcel :: execute()+ 0063字节,1575216028SYS-17010127/03/2018 09:15:20d:\ im_ds_4.2_sp08_patch_rel \ src\ dataservices \ dataintegrator \ codeline \ code \ src\ reader \ rdrexcel.cpp,第2312行1575216028SYS- 17010127/03/2018 09:15:200x00000000801CC210,XTran_desc :: execute()+ 0448字节,1575216028SYS-17010127/03/2018 09:15:20d:\ im_ds_4.2_sp08_patch_rel \ src\ dataservices \ dataintegrator \ codeline \ 代码\ src\ core \ xtran.cpp,行0812 1575216028SYS-17010127/03/2018 09:1 5:200x00000000811ACE45,Rww_thread :: main()+ 0261个字节,1575216028SYS-17010127/03/2018 09:15:20d:\ im_ds_4.2_sp08_patch_rel \ src\ dataservices \ dataintegrator \ codeline \ code \ src\ rww \ rwww .cpp,行0458 1575216028SYS-17010127/03/2018 09:15:200x0000000000A9438E,RWThreadFunctionImp :: run()+ 0126字节1575216028SYS-17010127/03/2018 09:15:200x0000000000A7C184,RWRunnableImp :: exec()+ 0372字节1575216028SYS-17010127/03/2018 09:15:200x0000000000A94643,RWThreadImp :: exec()+ 0051字节1575216028SYS-17010127/03/2018 09:15:200x0000000000A95F59,RWThreadImp :: _ setTimeSliceQuantum()+ 0169字节1575216028SYS-17010127/03/2018 09:15:200x00000000693D37D7,endthreadex()+ 0071字节1575216028SYS-17010127/03/2018 09:15:200x00000000693D3894,endthreadex()+ 0260字节1575216028SYS -17010127/03/2018 09:15:200x00000000C13413D2,BaseThreadInitThunk()+ 0034字节1575216028SYS-17010127/03/2018 09:15:200x00000000C38C54F4,RtlUserThreadStart()+ 0052字节1575216028SYS-17010127/03/2018 09:15:20寄存器:1 575216028SYS-17010127/03/2018 09:15:20RAX = 00000000A27C1370 RBX = 00000000103BDA80 RCX = 00000000A27C1370 RDX = 00000000103BDCB0 RSI = 0000000000000000 1575216028SYS-17010127/03/2018 09:15:20RDI = 00000000103BC00000000R00000000BBC00000000R00000000B = 0000000000010206 1575216028SYS-17010127/03/2018 09:15:20R8 = 0000000000000100 R9 = 0000000019930520 R10 = 00000000C38B57D0 R11 = 00000000103BB9C0 R12 = 00000000103BCA28 1575216028SYS-17010127/03/2018 09:15:20R13 = 00000000A2AEDB60 R14 = 15000000000000000000002 17010127/03/2018 09:15:20异常代码:C0000005 ACCESS_VIOLATION 1575216028SYS-17010127/03/2018 09:15:20故障地址:00007FFAA27C137D 01:000000000036037D C:\ Program Files \ Common Files \ Microsoft 1575216028SYS-17010127/03/2018 09 :15:20Shared \ Office16 \ mso40uiwin32client.dll 1575216028SYS-17010127/03/2018 09:15:20 ============================ ============================= 1575216028SYS-17010127/03/2018 09:15:20收集以下内容并发送给客户 支持:1575216028SYS-17010127/03/2018 09:15:201。 与此失败的作业关联的日志文件(error _ *,monitor _ *,trace_ *)。 1575216028SYS-17010127/03/2018 09:15:202 导出此失败作业的ATL文件。 1575216028SYS-17010127/03/2018 09:15:203。 在此失败的作业中引用的表的DDL语句。 1575216028SYS-17010127/03/2018 09:15:204。 用于填充失败作业中引用的表的数据。 如果不可能,请在1575216028SYS-17010127/03/2018 09:15:20作业失败时获取最后几行(或其中的一些示例)。 1575216028SYS-17010127/03/2018 09:15:205。 从此失败的作业生成的核心转储(如果有)。 1575216028SYS-17010127/03/2018 09:15:20 ====================================== ===================

3条回答
CPLASF-自律
2020-08-21 13:57

嗨,维奈,

您确定所有工作表的列格式(数据类型和长度)都完全相似。 同样,工作表名称也应与放置的所有Excel工作表匹配。

我在错误日志中看到一个访问冲突错误。

您在文件名中输入的文件名是什么...

您是否使用通配符搜索字符,例如 Source _ *。xlsx

致谢

阿伦·萨西

一周热门 更多>