nested exception is java.sql.SQLException
nested exception is java.sql.SQLException:Unknown initial character set index '*' received from server.Initial client character set can be forced via the 'characterEncoding' property.","results":[]} 问题原因 用户连接的数据...
常见报错
报错信息类似于以下形式：can not getTableTopology(drds*,ib_ibos*)Could not connect to address=(host=100.100.XX.XX)(port=*)(type=master):(conn=*)[10.0.1.1:3306]Access denied for user 'ib_ibos*'@'100.104.XX.XX' to database '...
Quick BI图表外部链接跳转报错“Failed to convert ...
nested exception is java.lang.NumberFormatException:For input string:"[order_id]"问题原因 图表数据集是SQL创建数据集，使用了 select*from.，跳转时没有找到具体的字段数据。解决方案 数据集SQL写成具体的字段，例如：select 字段1，...
QuickAudience创建受众报错“exceed table count ...
nested exception is java.sql.SQLException:CreateOperationFailed:MdsClient create table failed with an exception:Sending bsdbi_qa_adb table creation request to MDS server failed,error:{"code":20017,"message":"Exceed table ...
错误代码
示例：ERR-CODE:[TDDL-4203][ERR_SQL_QUERY_MERGE_TIMEOUT]Slow sql query leads to a timeout exception during merging results,please optimize the slow sql.The the default timeout is*ms.DB is*PolarDB-X 1.0 执行分布式查询超时，...
离线同步常见问题
读取PostgreSQL数据报错：org.postgresql.util.PSQLException:FATAL:terminating connection due to conflict with recovery 写入/读取MySQL报错：Application was streaming results when the connection failed.Consider raising value ...
错误码
示例：ERR-CODE:[PXC-4202][ERR_SQL_QUERY_TIMEOUT]Slow query leads to a timeout exception,please contact DBA to check slow sql.SocketTimout:*ms,Atom:*,Group:*,AppName:*,Env:*,UnitName:null.说明：该错误表示SQL语句在后端数据...
CDC问题
报错：EventDataDeserializationException:Failed to deserialize data of EventHeaderV4.Caused by:java.net.SocketException: Connection reset 报错：The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION=1,but the ...
上下游存储
Failed to create the job graph for the job:4b12318d861041ccb14d6e32bae9cec7(message=0:0-0:0,Translating the JobGraph for this deployment failed before.Please delete the JobGraph before requesting a new translation 报错：...
Dataphin中ClickHouse数据源DELETE准备语句执行报错
INFO ColumnCast-writerTimeZone is set to:[GMT+8]2023-01-04 17:20:33.153[main]INFO CalendarFactory-set CalendarFactory's timeZone to GMT+08:00 2023-01-04 17:20:33.154[main]INFO Engine-Dlink 开始运行.2023-01-04 17:20:33.190...
常见报错
报错示例：DBS-000000 Scheduling failed,the task has been retried,exceeding the maximum limit 解决方法：进入目标备份计划 备份任务配置 详情页，查看该备份计划的备份网关状态是否为 离线。根据备份计划的备份网关信息，请在 备份...
Proxool 连接池连接 OceanBase 数据库示例程序
代码如下：jdbc-1.proxool.maximum-connection-count=8 jdbc-1.proxool.minimum-connection-count=5 jdbc-1.proxool.prototype-count=4 jdbc-1.proxool.verbose=true jdbc-1.proxool.statistics=10s,1m,1d jdbc-1.proxool.statistics-log-...
JDBC
import java.sql.Connection;import java.sql.Driver;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.Properties;POLARDB JDBC DEMO**Please make ...
通过Spark Distribution SQL Engine开发Spark SQL作业
import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;public class TestHive { public static void main(String[]args)throws Exception { String hiveUrl=System.getenv(...
错误码
DTX-009 tcc 2.0 the java.sql.DataSource bean[%s]named by@TccBusinessAction.dataSourceBeanId()on class[%s]is not exist in spring applicationContext.@TccBusinessAction的dataSourceBeanId 属性指定的 DataSource bean 不存在。...
常见错误码及排查方法
DTS-31009:In process of processing data(recordRange:5799806987638145024)failed cause:CriticalAnyAllException:capture-dstore:DTS-51009:Failed to fetch records from dstore TimeoutException:Failed to get offsets by times in ...
应用程序连接示例
pwd'#Trying to establish connection connection,cursor=None,None try:connection=pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+password)cursor=...
EncDB SDK
EncdbSDKBuilder setDbConnection(java.sql.Connection dbConnection);（必选）设置全密态密钥管理类型 EncdbSDKBuilder setKeyMgmtType(KeyMgmtType kmType);（必选）设置用户主密钥 EncdbSDKBuilder setMek(byte[]mek);EncdbSDKBuilder ...
查询加速（MCQA）
每天每个项目并发限制5个，每天每个项目最多运行500个作业，超过部分默认设置自动回退为普通作业，如果您设置了不回退，系统会报如下错误：ODPS-1800001:Session exception-Failed to submit sub-query in session because:Prepaid project...
关键缺陷通知
text转bit报错不支持：Cast FROM STRING to BINARY is not supported.-text转bit，再转bigint报错：ERROR:syntax error at or near")"TEXT类型转BIT类型支持不完善，导致出现报错：Cast FROM STRING to BINARY is not supported....
Blink和Flink常见问题及诊断
报错：Failed to query table meta for table 可能原因：一种可能是用户读写了一张Hologres的外部表，Hologres Connector不支持读写外部表。如果不是，可能是Hologres实例 Meta出现了问题。解决方法：请联系Hologres技术支持人员。报错：...
SQL Server实例级别迁移上云
RDS SQL Server提供了 实例级别 的数据库迁移上云方案，支持将自建SQL Server的 多库或所有库的全量数据 迁移至阿里云RDS SQL Server。您只需先备份自建SQL Server的所有数据库，并将完整备份文件上传到OSS Bucket（存储空间）的同一文件夹...
公共错误码
诊断 400 InvalidExpired.Malformed The specified"Expired"is not valid.-诊断 400 ConnectionStringContainIllegalCharacterFault The connection string contain Illegal character.连接字符串内容存在非法字符错误，请修改后重试。诊断...
公共错误码
诊断 400 InvalidExpired.Malformed The specified"Expired"is not valid.-诊断 400 ConnectionStringContainIllegalCharacterFault The connection string contain Illegal character.连接字符串内容存在非法字符错误，请修改后重试。诊断...
公共错误码
诊断 400 InvalidExpired.Malformed The specified"Expired"is not valid.-诊断 400 ConnectionStringContainIllegalCharacterFault The connection string contain Illegal character.连接字符串内容存在非法字符错误，请修改后重试。诊断...
公共错误码
诊断 400 InvalidExpired.Malformed The specified"Expired"is not valid.-诊断 400 ConnectionStringContainIllegalCharacterFault The connection string contain Illegal character.连接字符串内容存在非法字符错误，请修改后重试。诊断...
公共错误码
诊断 400 InvalidExpired.Malformed The specified"Expired"is not valid.-诊断 400 ConnectionStringContainIllegalCharacterFault The connection string contain Illegal character.连接字符串内容存在非法字符错误，请修改后重试。诊断...
Oracle2PolarDB：Polardb-O兼容性之fetchsize
trip for a query,and this number is referred to as the fetch size.In Oracle JDBC,the row-prefetch value is used as the default fetch size in a statement object.Setting the fetch size overrides the row-prefetch setting and ...
使用JDBC Connector同步MySQL数据
本文介绍如何创建JDBC Connector，将MySQL和 云消息队列 Kafka 版 的数据进行互相同步。前提条件 已开通事件总线EventBridge并授权。已开通对象存储OSS服务并创建存储空间（Bucket）。更多信息，请参见 控制台创建存储空间。已开通...
使用JDBC Connector同步MySQL数据
本文介绍如何创建JDBC Connector，将MySQL和 云消息队列 Kafka 版 的数据进行互相同步。前提条件 已开通事件总线EventBridge并授权。已开通对象存储OSS服务并创建存储空间（Bucket）。更多信息，请参见 控制台创建存储空间。已开通...
SQL常见问题
SQL校验报错信息如下：org.apache.flink.table.api.ValidationException:SQL validation failed.Column types of query result and sink for 'vvp.default.sink' do not match.Cause:Sink column 'f1' at position 0 is of type INT but ...
附录：API调用示例
JAVA SDK调用方式 JAVA SDK简介 Dataphin服务Java SDK是根据您自定义的所有API接口，自动生成的Java调用代码，让您无需复杂编程即可访问Dataphin服务。这里向您介绍如何使用Dataphin服务SDK。代码文件的层级结构如下：Java SDK文件夹 sdk/...
公共错误码
诊断 500 CreateOrderFailed.UseCoupon The Account failed to create order with coupon.-诊断 500 CreateOrderFailed.UseStoreCard The Account failed to create order with store card.-诊断 503 SOCKET_TIMEOUT_ERROR java....
公共错误码
诊断 500 CreateOrderFailed.UseCoupon The Account failed to create order with coupon.-诊断 500 CreateOrderFailed.UseStoreCard The Account failed to create order with store card.-诊断 503 SOCKET_TIMEOUT_ERROR java....
公共错误码
诊断 500 CreateOrderFailed.UseCoupon The Account failed to create order with coupon.-诊断 500 CreateOrderFailed.UseStoreCard The Account failed to create order with store card.-诊断 503 SOCKET_TIMEOUT_ERROR java....
公共错误码
诊断 500 CreateOrderFailed.UseCoupon The Account failed to create order with coupon.-诊断 500 CreateOrderFailed.UseStoreCard The Account failed to create order with store card.-诊断 503 SOCKET_TIMEOUT_ERROR java....
公共错误码
诊断 500 CreateOrderFailed.UseCoupon The Account failed to create order with coupon.-诊断 500 CreateOrderFailed.UseStoreCard The Account failed to create order with store card.-诊断 503 SOCKET_TIMEOUT_ERROR java....
公共错误码
诊断 500 CreateOrderFailed.UseCoupon The Account failed to create order with coupon.-诊断 500 CreateOrderFailed.UseStoreCard The Account failed to create order with store card.-诊断 503 SOCKET_TIMEOUT_ERROR java....
公共错误码
诊断 500 CreateOrderFailed.UseCoupon The Account failed to create order with coupon.-诊断 500 CreateOrderFailed.UseStoreCard The Account failed to create order with store card.-诊断 503 SOCKET_TIMEOUT_ERROR java....
Quick BI中ClickHouse数据源自定义SQL创建数据集可以...
nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'sql_text' at row 1 \torg.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:...
- 产品推荐
- 这些文档可能帮助您