Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

接收到全局消息me: {{failed MYSQL,Script未知 -1 map[] <nil>} MYSQL,Script未知} #1

Closed
lscool66 opened this issue Jul 27, 2022 · 3 comments

Comments

@lscool66
Copy link

接收到全局消息me: {{failed MYSQL,Script未知 -1 map[] } MYSQL,Script未知}
image

@lscool66
Copy link
Author

<?xml version="1.0" encoding="UTF-8"?> <Graph> <Node id="rcp" dbConnection="mysqlout1_rcp" type="DB_INPUT_TABLE" desc="mysqlout1_rcp" fetchSize="1000"> <Script name="sqlScript"> <![CDATA[ select * from (select * from rcp_sap_tube_state) ]]> </Script> </Node> <Node id="rdp" dbConnection="mysqlout1_rdp" type="DB_OUTPUT_TABLE" desc="mysqlout1_rdp" outputFields="tube_id;barcode;state;update_time;update_user_id;approve_user_id;approve_time;approve_state;upload_status;reviewer_lab_id;patient_num;census_address_id;create_time;incept_time;incept_laboratory_id;modify_time;modifier" renameOutputFields="tube_id;barcode;state;update_time;update_user_id;approve_user_id;approve_time;approve_state;upload_status;reviewer_lab_id;patient_num;census_address_id;create_time;incept_time;incept_laboratory_id;modify_time;modifier"></Node> <Line id="LINE_01" type="STANDARD" from="rcp" to="rdp" order="0" metadata="rcp_sap_tube_state"></Line> <Metadata id="rcp_sap_tube_state"> <Field name="tube_id" type="string" default="" nullable="false" /> <Field name="barcode" type="string" default="" nullable="true" /> <Field name="state" type="string" default="" nullable="true" /> <Field name="update_time" type="string" default="" nullable="true" /> <Field name="patient_num" type="string" default="" nullable="false" /> <Field name="census_address_id" type="string" default="" nullable="false" /> <Field name="modify_time" type="string" default="" nullable="false" /> </Metadata> <Connection id="mysqlout1_rcp" dbURL="127.0.0.1:3306" database="rcp" username="root" password="66666" type="MYSQL" /> <Connection id="mysqlout1_rdp" dbURL="127.0.0.1:3306" database="rdp" username="root" password="66666" type="MYSQL" /> </Graph>

@hw2499
Copy link
Owner

hw2499 commented Jul 28, 2022

需要在输出节点DB_OUTPUT_TABLE中通过Script标签来写insert语句,以实现写入数据表能力(influxdb不需要用Script标签,mysql,ck都需要通过Script标签),如下:

<Script name="sqlScript"></Script> 更加详细的日志输出,可通过 -logLevel trace 看到

@hw2499
Copy link
Owner

hw2499 commented Jul 28, 2022

i1.png

@hw2499 hw2499 closed this as completed Jul 23, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants