开发者社区> 问答> 正文

ADAM对上传数据集分析失败,提示“采集数据中缺乏SQL数据"

数据采集成功后,分析失败,提示提示“采集数据中缺乏SQL数据",不知哪里有问题了

以下是采集日志:

[main] INFO CollectionService - 共创建slave节点[0]个:[]

[main] INFO OracleDumpService - 开启源数据库连接:driver[oracle.jdbc.driver.OracleDriver],url[192.168.1.8],port[1521],sid[null],serviceName[orcl]
[main] INFO OracleDumpService - 当前数据库编码集为[AL32UTF8], 对应字符编码集为[UTF-8]
[main] INFO VersionService - 当前数据库版本:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
[main] INFO ValidateService - 校验数据库权限结果为:[11111]
[main] INFO ValidateService - 校验ArchivedLog结果为:[11]
[main] INFO VersionService - 加载采集配置文件:[script/rainmeter.11g]
[pool-1-thread-4] INFO MonitorService - 当前配置Load阀值为[2.0]
[main] INFO VersionService - 目标数据库信息 开始**
[main] INFO VersionService - Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
[main] INFO VersionService - PL/SQL Release 11.2.0.1.0 - Production
[main] INFO VersionService - CORE 11.2.0.1.0 Production
[main] INFO VersionService - TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
[main] INFO VersionService - NLSRTL Version 11.2.0.1.0 - Production
[pool-1-thread-4] INFO MonitorService - 当前负载值:numCpuCores[4.0], load[0.05956449894846397], percent[2.0]
[pool-1-thread-4] INFO MonitorService - 当前服务器状态:[正常]
[main] INFO VersionService - 目标数据库信息 结束**
[main] INFO CollectService - 开始采集完整数据于[2018-05-31 22:55:59]
[main] INFO ConstraintDumpProcessor - 总共收集到eoa_tmp_constraints条数据
[main] INFO ConstraintDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_constraints.csv]文件成功.
[main] INFO ConstraintColumnProcessor - 总共收集到eoa_tmp_constraint_columns条数据
[main] INFO ConstraintColumnProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_constraint_columns.csv]文件成功.
[main] INFO DatabaseDumpProcessor - 总共收集到eoa_tmp_database条数据
[main] INFO DatabaseDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_database.csv]文件成功.
[main] INFO DatabaseObjectDumpProcessor - 总共收集到eoa_tmp_objects条数据
[main] INFO DatabaseObjectDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_objects.csv]文件成功.
[main] INFO DatabaseObjectExtDumpProcessor - 总共收集到eoa_tmp_objects_ext条数据
[main] INFO DatabaseObjectExtDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_objects_ext.csv]文件成功.
[main] INFO DatabaseParameterDumpProcessor - 总共收集到eoa_tmp_database_parameters条数据
[main] INFO DatabaseParameterDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_database_parameters.csv]文件成功.
[main] INFO DBLinkDumpProcessor - 总共收集到eoa_tmp_db_links条数据
[main] INFO DBLinkDumpProcessor - [eoa_tmp_db_links]无数据,不生成CSV文件
[main] INFO DDLDumpProcessor - 总共收集到eoa_tmp_object_ddl条数据
[main] INFO DDLDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_object_ddl.csv]文件成功.
[main] INFO DependencyDumpProcessor - 总共收集到eoa_tmp_dependencies条数据
[main] INFO DependencyDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_dependencies.csv]文件成功.
[main] INFO IndexColumnDumpProcessor - 总共收集到eoa_tmp_ind_columns条数据
[main] INFO IndexColumnDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_ind_columns.csv]文件成功.
[main] INFO IndexDumpProcessor - 总共收集到eoa_tmp_indexes条数据
[main] INFO IndexDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_indexes.csv]文件成功.
[main] INFO JobDumpProcessor - 总共收集到eoa_tmp_jobs条数据
[main] INFO JobDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_jobs.csv]文件成功.
[main] INFO LobDumpProcessor - 总共收集到eoa_tmp_lobs条数据
[main] INFO LobDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_lobs.csv]文件成功.
[main] INFO MViewDumpProcessor - 总共收集到eoa_tmp_mviews条数据
[main] INFO MViewDumpProcessor - [eoa_tmp_mviews]无数据,不生成CSV文件
[main] INFO OSStatDumpProcessor - 总共收集到eoa_tmp_osstat条数据
[main] INFO OSStatDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_osstat.csv]文件成功.
[main] INFO ProcedureDumpProcessor - 总共收集到eoa_tmp_procedures条数据
[main] INFO ProcedureDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_procedures.csv]文件成功.
[main] INFO QPSDumpProcessor - 总共收集到eoa_tmp_qps条数据
[main] INFO QPSDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_qps.csv]文件成功.
[main] INFO SchedulerJobDumpProcessor - 总共收集到eoa_tmp_scheduler_jobs条数据
[main] INFO SchedulerJobDumpProcessor - [eoa_tmp_scheduler_jobs]无数据,不生成CSV文件
[main] INFO SchedulerProgramArgDumpProcessor - 总共收集到eoa_tmp_scheduler_programs_args条数据
[main] INFO SchedulerProgramArgDumpProcessor - [eoa_tmp_scheduler_programs_args]无数据,不生成CSV文件
[main] INFO SchedulerProgramDumpProcessor - 总共收集到eoa_tmp_scheduler_programs条数据
[main] INFO SchedulerProgramDumpProcessor - [eoa_tmp_scheduler_programs]无数据,不生成CSV文件
[main] INFO SegmentDumpProcessor - 总共收集到eoa_tmp_segments条数据
[main] INFO SegmentDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_segments.csv]文件成功.
[main] INFO SequenceDumpProcessor - 总共收集到eoa_tmp_sequences条数据
[main] INFO SequenceDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_sequences.csv]文件成功.
[main] INFO SessionDumpProcessor - 总共收集到eoa_tmp_session_hist条数据
[main] INFO SessionDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_session_hist.csv]文件成功.
[main] INFO SourceDumpProcessor - 总共收集到eoa_tmp_source条数据
[main] INFO SourceDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_source.csv]文件成功.
[main] INFO SqlareaDumpProcessor - 总共收集到eoa_tmp_sqlarea条数据
[main] INFO SqlareaDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_sqlarea.csv]文件成功.
[main] INFO SqlStatDumpProcessor - 总共收集到eoa_tmp_hist_sqlstat条数据
[main] INFO SqlStatDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_hist_sqlstat.csv]文件成功.
[main] INFO SqlTextDumpProcessor - 总共得到1064条sqlText记录
[main] INFO SqlTextDumpProcessor - 总共收集到eoa_tmp_hist_sqltext条数据
[main] INFO SqlTextDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_hist_sqltext.csv]文件成功.
[main] INFO SynonymDumpProcessor - 总共收集到eoa_tmp_synonyms条数据
[main] INFO SynonymDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_synonyms.csv]文件成功.
[main] INFO SystemMetricDumpProcessor - 总共收集到eoa_tmp_system_metric条数据
[main] INFO SystemMetricDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_system_metric.csv]文件成功.
[main] INFO TableColumnDumpProcessor - 总共收集到eoa_tmp_tab_columns条数据
[main] INFO TableColumnDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_tab_columns.csv]文件成功.
[main] INFO TableDumpProcessor - 总共收集到eoa_tmp_tables条数据
[main] INFO TableDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_tables.csv]文件成功.
[main] INFO TablePrivDumpProcessor - 总共收集到eoa_tmp_tab_priv条数据
[main] INFO TablePrivDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_tab_priv.csv]文件成功.
[main] INFO TPSDumpProcessor - 总共收集到eoa_tmp_tps条数据
[main] INFO TPSDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_tps.csv]文件成功.
[main] INFO TransactionSqlDumpProcessor - archivedLog采集Time[2018-05-30 09:00:00~2018-05-30 18:00:00]间的数据
[main] WARN TransactionSqlDumpProcessor - 获取不到任何archived log信息
[main] INFO TransactionSqlDumpProcessor - archivedLog采集Time[2018-05-29 09:00:00~2018-05-29 18:00:00]间的数据
[main] WARN TransactionSqlDumpProcessor - 获取不到任何archived log信息
[main] INFO TransactionSqlDumpProcessor - archivedLog采集Time[2018-05-28 09:00:00~2018-05-28 18:00:00]间的数据
[main] WARN TransactionSqlDumpProcessor - 获取不到任何archived log信息
[main] INFO TransactionSqlDumpProcessor - archivedLog采集Time[2018-05-30 18:00:00~2018-05-31 23:01:48]间的数据
[main] INFO TransactionSqlDumpProcessor - 待处理的archived log文件共[1]个
[main] INFO TransactionSqlDumpProcessor - 每次处理archivedLog文件的大小为[500.0]MB.
[main] INFO TransactionSqlDumpProcessor - [1]个事务文件转表结果:true
[pool-1-thread-4] INFO MonitorService - 当前配置Load阀值为[2.0]
[pool-1-thread-4] INFO MonitorService - 当前负载值:numCpuCores[4.0], load[0.11978271593036839], percent[2.0]
[pool-1-thread-4] INFO MonitorService - 当前服务器状态:[正常]
[main] INFO TransactionSqlDumpProcessor - 获得[256]条transaction记录
[main] INFO TransactionSqlDumpProcessor - 总共收集到eoa_tmp_trans_sql条数据
[main] INFO TransactionSqlDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_trans_sql.csv]文件成功.
[main] INFO TriggerDumpProcessor - 总共收集到eoa_tmp_triggers条数据
[main] INFO TriggerDumpProcessor - [eoa_tmp_triggers]无数据,不生成CSV文件
[main] INFO ViewDumpProcessor - 总共收集到eoa_tmp_views条数据
[main] INFO ViewDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_views.csv]文件成功.
[main] INFO VersionDumpProcessor - 总共收集到eoa_tmp_versions条数据
[main] INFO VersionDumpProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_versions.csv]文件成功.
[main] INFO TransactionDumpProcessor - 限制收集[eoa_tmp_transactions]数据
[main] INFO ParameterProcessor - 总共收集到eoa_tmp_parameter条数据
[main] INFO ParameterProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_parameter.csv]文件成功.
[main] INFO TypeProcessor - 总共收集到eoa_tmp_types条数据
[main] INFO TypeProcessor - 生成[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160eoa_tmp_types.csv]文件成功.
[main] INFO CollectService - 于[2018-05-31 23:09:14]结束采集完整数据
[main] INFO ValidateService - 总共有[3]个待打包的文件夹。
[main] INFO ValidateService - 开始校验文件:[E:PPASrainmeterdump0ce58e061107f0ff23318ab9f054c1921527776636497summary.txt]
[main] WARN ValidateService - 存在不完整的数据:[sqltext]
[main] WARN ValidateService - 存在不完整的数据:[sqlarea]
[main] INFO ValidateService - 开始校验文件:[E:PPASrainmeterdump0ce58e061107f0ff23318ab9f054c1921527777427032summary.txt]
[main] WARN ValidateService - 存在不完整的数据:[sqltext]
[main] WARN ValidateService - 存在不完整的数据:[sqlarea]
[main] INFO ValidateService - 开始校验文件:[E:PPASrainmeterdump4e00675c038d4875b986fc6bd2e615771527778559160summary.txt]
[main] INFO ValidateService - 校验数据完整性结果:11111111111111

展开
收起
epsoft 2018-06-01 09:09:32 3662 0
1 条回答
写回答
取消 提交回答
  • 个人建议要看你数据库中的另外的相关字段,如果可以,可以建立联合主键;需要你提供相关数据库表的信息
    

    “答案来源于网络,供您参考” 希望以上信息可以帮到您!

    2019-09-27 13:38:11
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
SQL Server 2017 立即下载
GeoMesa on Spark SQL 立即下载
原生SQL on Hadoop引擎- Apache HAWQ 2.x最新技术解密malili 立即下载