• 无效的月份


    NSDZHSCMFP01Administrator. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.1600.1 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  12:26:07  Error: 2021-03-11 12:27:57.74     Code: 0xC002F210     Source: SAP_OSAL_OUT Execute SQL Task     Description: Executing the query "INSERT INTO STG.SAP_OSAL_OUT(VBELN, POSNR, ETENR, ..." failed with the following error: "ERROR [HY000] [Oracle][ODBC][Ora]ORA-01843: 无效的月份  ". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.  End Error  DTExec: The package execution returned DTSER_FAILURE (1). 

    --INSERT INTO STG.SAP_OSAL_OUT(VBELN, POSNR, ETENR, EDATU, BMENG, YJHSL, WJHSL)
    SELECT VBELN,
    POSNR,
    ETENR,EDATU,
    --TO_DATE(SUBSTR(EDATU,1,4)||'-'||SUBSTR(EDATU,5,2)||'-'||SUBSTR(EDATU,7,2),'YYYY-MM-DD') AS EDATU,
    BMENG,
    YJHSL,
    WJHSL
    FROM SAPSR3.ZTFP_SO_SCHED@SAP_SEP
    WHERE EDATU='00000000'
    ;

  • 相关阅读:
    下载文件 文件名 乱码的问题.
    Powershell 变量
    20101227 [随笔] Roy
    20101022 [随笔] Roy
    20100927 [随笔] Roy
    20101209 [随笔] Roy
    20101123 [随笔] Roy
    20101213 [随笔] Roy
    第一 笔记
    分享Sokcet方式请求HTTP/HTTPS的封装类HttpHelper V2
  • 原文地址:https://www.cnblogs.com/Snowfun/p/14517190.html
Copyright © 2020-2023  润新知