Hi,
to summarize, it seems like some moron has deactivated a layout, did not stop ETL and then added some new agents, and then activated the layout. This causes major problems with ETL 7.2, because anything added during the deactivated period is not synchronized and causes a helluva of a problems later on. This is a known bug with 7.2 ETL.
Now, ETL is refusing to bring over any data since then, and we are stuck. I need some major help on how to deal with it. Does anyone know how to handle it? Java returns: java.sql.SQLException: database object name 'V_55_COMPSTAT' already exists. Please help...
08:47:38.683 LFolder.TableRegister creating new VIEW: V_55_COMPSTAT
08:47:38.730 LFolder.TableRegister failed sql: create view V_55_COMPSTAT as SELECT STAT_RES.OBJECT_ID OBJECT_ID, STAT_RES.TIME_KEY TIME_KEY ,case T_LOGIN when 0 then 0 else convert( float, N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN ) * 3600 / T_LOGIN end AV_N_CALLS_P_HOUR,case N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN when 0 then 0 else convert( float, T_INBOUND + T_OUTBOUND + T_INTERNAL + T_CONSULT + T_UNKNOWN ) / ( N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN ) end AV_T_CALLS,case N_CONSULT when 0 then 0 else convert( float, T_CONSULT ) / N_CONSULT end AV_T_CONSULT,case N_INBOUND + N_OUTBOUND when 0 then 0 else convert( float, T_INBOUND + T_OUTBOUND ) / ( N_INBOUND + N_OUTBOUND ) end AV_T_CUST_CALLS,case N_DIALING when 0 then 0 else convert( float, T_DIALING ) / N_DIALING end AV_T_DIALING,case N_INBOUND + N_OUTBOUND when 0 then 0 else convert( float, T_INBOUND + T_OUTBOUND+T_WORK ) / ( N_INBOUND + N_OUTBOUND ) end AV_T_HANDLE,case N_HOLD when 0 then 0 else convert( float, T_HOLD ) / N_HOLD end AV_T_HOLD,case N_INBOUND when 0 then 0 else convert( float, T_INBOUND ) / N_INBOUND end AV_T_INBOUND,case N_INTERNAL when 0 then 0 else convert( float, T_INTERNAL ) / N_INTERNAL end AV_T_INTERNAL,case N_NOT_READY when 0 then 0 else convert( float, T_NOT_READY ) / N_NOT_READY end AV_T_NOT_READY,case N_OUTBOUND when 0 then 0 else convert( float, T_OUTBOUND ) / N_OUTBOUND end AV_T_OUTBOUND,case N_RINGING when 0 then 0 else convert( float, T_RINGING ) / N_RINGING end AV_T_RINGING,case N_INTERNAL + N_CONSULT when 0 then 0 else convert( float, T_INTERNAL + T_CONSULT ) / ( N_INTERNAL + N_CONSULT ) end AV_T_SRV_CALLS,case N_UNKNOWN when 0 then 0 else convert( float, T_UNKNOWN ) / N_UNKNOWN end AV_T_UNKNOWN,case N_WAIT when 0 then 0 else convert( float, T_WAIT ) / N_WAIT end AV_T_WAIT,case N_WORK when 0 then 0 else convert( float, T_WORK ) / N_WORK end AV_T_WORK, N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN N_CALLS, N_CONFERENCES N_CONFERENCES, N_CONSULT N_CONSULT, N_INBOUND + N_OUTBOUND N_CUST_CALLS, N_DIALING N_DIALING, N_HOLD N_HOLD, N_INBOUND N_INBOUND, N_INTERNAL N_INTERNAL, N_NOT_READY N_NOT_READY, N_OUTBOUND N_OUTBOUND, N_RINGING N_RINGING, N_INTERNAL + N_CONSULT N_SRV_CALLS,N_TALK N_TALK, N_TRANSFERS_MADE N_TRANSFERS_MADE, N_TRANSFERS_TAKEN N_TRANSFERS_TAKEN, N_UNKNOWN N_UNKNOWN, N_WAIT N_WAIT, N_WORK N_WORK,case when N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN = 0 then 0 when N_CONFERENCES > N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN then 100 else convert( float, N_CONFERENCES ) * 100 / ( N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN ) end PC_N_CONFERENCES,case N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN when 0 then 0 else convert( float, N_CONSULT ) * 100 / ( N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN ) end PC_N_CONSULT,case N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN when 0 then 0 else convert( float, N_INBOUND + N_OUTBOUND ) * 100 / ( N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN ) end PC_N_CUST_CALLS,case when N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN = 0 then 0 when N_HOLD > N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN then 100 else convert( float, N_HOLD ) * 100 / ( N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN ) end PC_N_HOLD,case N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN when 0 then 0 else convert( float, N_INBOUND ) * 100 / ( N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN ) end PC_N_INBOUND,case N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN when 0 then 0 else convert( float, N_INTERNAL ) * 100 / ( N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN ) end PC_N_INTERNAL,case N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN when 0 then 0 else convert( float, N_OUTBOUND ) * 100 / ( N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN ) end PC_N_OUTBOUND,case N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN when 0 then 0 else convert( float, N_INTERNAL + N_CONSULT ) * 100 / ( N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN ) end PC_N_SRV_CALLS,case when N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN = 0 then 0 when N_TRANSFERS_MADE > N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN then 100 else convert( float, N_TRANSFERS_MADE ) * 100 / ( N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN ) end PC_N_TRANS_MADE,case when N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN = 0 then 0 when N_TRANSFERS_TAKEN > N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN then 100 else convert( float, N_TRANSFERS_TAKEN ) * 100 / ( N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN ) end PC_N_TRANS_TAKEN,case N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN when 0 then 0 else convert( float, N_UNKNOWN ) * 100 / ( N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN ) end PC_N_UNKNOWN,case when N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN = 0 then 0 when N_WORK > N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN then 100 else convert( float, N_WORK ) * 100 / ( N_INBOUND + N_OUTBOUND + N_INTERNAL + N_CONSULT + N_UNKNOWN ) end PC_N_WORK,case when T_LOGIN = 0 then 0 when T_INBOUND + T_OUTBOUND + T_INTERNAL + T_CONSULT + T_UNKNOWN > T_LOGIN then 100 else convert( float, T_INBOUND + T_OUTBOUND + T_INTERNAL + T_CONSULT + T_UNKNOWN ) * 100 / T_LOGIN end PC_T_CALLS,case when T_LOGIN = 0 then 0 when T_CONSULT > T_LOGIN then 100 else convert( float, T_CONSULT ) * 100 / T_LOGIN end PC_T_CONSULT,case when T_LOGIN = 0 then 0 when T_INBOUND + T_OUTBOUND > T_LOGIN then 100 else convert( float, T_INBOUND + T_OUTBOUND ) * 100 / T_LOGIN end PC_T_CUST_CALLS,case when T_LOGIN = 0 then 0 when T_DIALING > T_LOGIN then 100 else convert( float, T_DIALING ) * 100 / T_LOGIN end PC_T_DIALING,case when T_LOGIN = 0 then 0 when T_HOLD > T_LOGIN then 100 else convert( float, T_HOLD ) * 100 / T_LOGIN end PC_T_HOLD,case when T_LOGIN = 0 then 0 when T_INBOUND > T_LOGIN then 100 else convert( float, T_INBOUND ) * 100 / T_LOGIN end PC_T_INBOUND,case when T_LOGIN = 0 then 0 when T_INTERNAL > T_LOGIN then 100 else convert( float, T_INTERNAL ) * 100 / T_LOGIN end PC_T_INTERNAL,case when T_LOGIN = 0 then 0 when T_NOT_READY > T_LOGIN then 100 else convert( float, T_NOT_READY ) * 100 / T_LOGIN end PC_T_NOT_READY,case when T_LOGIN = 0 then 0 when T_OUTBOUND > T_LOGIN then 100 else convert( float, T_OUTBOUND ) * 100 / T_LOGIN end PC_T_OUTBOUND,case when T_LOGIN = 0 then 0 when T_RINGING > T_LOGIN then 100 else convert( float, T_RINGING ) * 100 / T_LOGIN end PC_T_RINGING,case when T_LOGIN = 0 then 0 when T_INTERNAL + T_CONSULT > T_LOGIN then 100 else convert( float, T_INTERNAL + T_CONSULT ) * 100 / T_LOGIN end PC_T_SRV_CALLS,case when T_LOGIN = 0 then 0 when T_UNKNOWN > T_LOGIN then 100 else convert( float, T_UNKNOWN ) * 100 / T_LOGIN end PC_T_UNKNOWN,case when T_LOGIN = 0 then 0 when T_WAIT > T_LOGIN then 100 else convert( float, T_WAIT ) * 100 / T_LOGIN end PC_T_WAIT,case when T_LOGIN = 0 then 0 when T_WORK > T_LOGIN then 100 else convert( float, T_WORK ) * 100 / T_LOGIN end PC_T_WORK, T_INBOUND + T_OUTBOUND + T_INTERNAL + T_CONSULT + T_UNKNOWN T_CALLS, T_CONSULT T_CONSULT, T_INBOUND + T_OUTBOUND T_CUST_CALLS, T_DIALING T_DIALING, T_HOLD T_HOLD, T_INBOUND T_INBOUND, T_INTERNAL T_INTERNAL, T_LOGIN T_LOGIN, T_NOT_READY T_NOT_READY, T_OUTBOUND T_OUTBOUND, T_RINGING T_RINGING, T_INTERNAL + T_CONSULT T_SRV_CALLS,T_TALK T_TALK, T_UNKNOWN T_UNKNOWN, T_WAIT T_WAIT, T_WORK T_WORK FROM R_55_STAT_RES STAT_RES
08:47:38.730 LFolder Unable to instantiate folder:LayoutFolder[l:id0_7,f:43]
08:47:38.730 LFolder SQLState: S0001
08:47:38.730 LFolder Vendor: 2714
08:47:38.730 LFolder Stack Trace:
08:47:38.730 LFolder java.sql.SQLException: データベースにオブジェクト名 'V_55_COMPSTAT' が既に存在します。
