Hello guys, I created a process that uses the Login Information Parser smart service. I created the table in an Oracle database with the script below and then I ran the process without specifying a date and also specifying a date. In both instances, the server logs is showing the error:
20:06:52,460 ERROR [stderr] (Appian Work Item - 12585 - ProcessExec01 : UnattendedJavaActivityRequest) java.sql.SQLDataException: ORA-01843: not a valid month
Seems to me like the plugin has a defect. Am I missing anything?
CREATE TABLE logins ( "date" DATE, "time" TIMESTAMP (9), "lineNumber" NUMBER (10, 0), "isValidLogin" NUMBER (1, 0), "username" VARCHAR2 (100 CHAR), "ipaddress" VARCHAR2 (20 CHAR), CONSTRAINT "SUPPLIER_UNIQUE" UNIQUE ("lineNumber") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE (INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE (INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS";
Discussion posts and replies are publicly visible