Cobub Razor 0.4 事件列表与新增用户数据不准

[jiong056]

查看mysql中发现表少了很多，这是什么原因？ mysql> show tables; +------------------------+ | Tables_in_razor | +------------------------+ | razor_alert | | razor_alertdetail | | razor_cell_towers | | razor_channel | | razor_channel_product | | razor_ci_sessions | | razor_clientdata | | razor_clientusinglog | | razor_config | | razor_errorlog | | razor_event_defination | | razor_eventdata | | razor_login_attempts | | razor_markevent | | razor_mccmnc | | razor_networktype | | razor_platform | | razor_product | | razor_product_category | | razor_product_version | | razor_productfiles | | razor_reportlayout | | razor_target | | razor_targetevent | | razor_user2role | | razor_user_autologin | | razor_user_permissions | | razor_user_profiles | | razor_user_resources | | razor_user_roles | | razor_users | | razor_wifi_towers | +------------------------+ 32 rows in set (0.00 sec)

[kansifang]

这些是Cobub Razor系统自带的表，你指的少表我没明白你是指少的是什么表？

ownerme

发件人： jiong056 发送时间： 2013-11-07 12:48 收件人： cobub/razor 主题： [razor] Cobub Razor 0.4 事件列表与新增用户数据不准 (#101) 查看mysql中发现表少了很多，这是什么原因？ mysql> show tables; +------------------------+ | Tables_in_razor | +------------------------+ | razor_alert | | razor_alertdetail | | razor_cell_towers | | razor_channel | | razor_channel_product | | razor_ci_sessions | | razor_clientdata | | razor_clientusinglog | | razor_config | | razor_errorlog | | razor_event_defination | | razor_eventdata | | razor_login_attempts | | razor_markevent | | razor_mccmnc | | razor_networktype | | razor_platform | | razor_product | | razor_product_category | | razor_product_version | | razor_productfiles | | razor_reportlayout | | razor_target | | razor_targetevent | | razor_user2role | | razor_user_autologin | | razor_user_permissions | | razor_user_profiles | | razor_user_resources | | razor_user_roles | | razor_users | | razor_wifi_towers | +------------------------+ 32 rows in set (0.00 sec) — Reply to this email directly or view it on GitHub.

[jiong056]

我重新装了另一个Cobub Razor，发现有一下表： +-------------------------------------+ | Tables_in_test | +-------------------------------------+ | razor_alert | | razor_alertdetail | | razor_cell_towers | | razor_channel | | razor_channel_product | | razor_ci_sessions | | razor_clientdata | | razor_clientusinglog | | razor_config | | razor_dim_activity | | razor_dim_date | | razor_dim_devicebrand | | razor_dim_devicelanguage | | razor_dim_deviceos | | razor_dim_deviceresolution | | razor_dim_devicesupplier | | razor_dim_errortitle | | razor_dim_event | | razor_dim_location | | razor_dim_network | | razor_dim_product | | razor_dim_segment_launch | | razor_dim_segment_usinglog | | razor_errorlog | | razor_event_defination | | razor_eventdata | | razor_fact_clientdata | | razor_fact_errorlog | | razor_fact_event | | razor_fact_launch_daily | | razor_fact_usinglog | | razor_fact_usinglog_daily | | razor_getui_product | | razor_hour24 | | razor_log | | razor_login_attempts | | razor_markevent | | razor_mccmnc | | razor_networktype | | razor_platform | | razor_plugins | | razor_product | | razor_product_category | | razor_product_version | | razor_productfiles | | razor_reportlayout | | razor_sum_accesslevel | | razor_sum_accesspath | | razor_sum_basic_activeusers | | razor_sum_basic_byhour | | razor_sum_basic_channel | | razor_sum_basic_channel_activeusers | | razor_sum_basic_product | | razor_sum_basic_product_version | | razor_sum_reserveusers_daily | | razor_sum_reserveusers_monthly | | razor_sum_reserveusers_weekly | | razor_sum_usinglog_activity | | razor_tag_group | | razor_target | | razor_targetevent | | razor_user2product | | razor_user2role | | razor_user_autologin | | razor_user_permissions | | razor_user_profiles | | razor_user_resources | | razor_user_roles | | razor_userkeys | | razor_users | | razor_wifi_towers | +-------------------------------------+

这些表| razor_dim_activity | | razor_dim_date | | razor_dim_devicebrand | | razor_dim_devicelanguage | | razor_dim_deviceos | | razor_dim_deviceresolution | | razor_dim_devicesupplier | | razor_dim_errortitle | | razor_dim_event | | razor_dim_location | | razor_dim_network | | razor_dim_product | | razor_dim_segment_launch | | razor_dim_segment_usinglog |好像丢失了，并且我在代码中发现调用select e.event_sk, e.eventidentifier, e.eventname, count(f.eventid) count from razor_dim_product p, razor_fact_event f, razor_dim_event e where p.product_id=2 and p.product_active=1 and p.channel_active=1 and p.version_active=1 and f.product_sk = p.product_sk and f.event_sk = e.event_sk group by e.event_sk,e.eventidentifier, e.eventname order by e.event_sk desc;语句时去获取事件列表失败

[kansifang]

在安装到第四步 创建数据库时 Cobub Razor的原始数据库和数据仓库 是使用的同一个数据库还分开的？你第一次建立应该是使用了不同的数据库，第二次应该是用的是同一个数据库

ownerme

发件人： jiong056 发送时间： 2013-11-07 13:27 收件人： cobub/razor 抄送： kansifang 主题： Re: [razor] Cobub Razor 0.4 事件列表与新增用户数据不准 (#101) 我重新装了另一个Cobub Razor，发现有一下表： +-------------------------------------+ | Tables_in_test | +-------------------------------------+ | razor_alert | | razor_alertdetail | | razor_cell_towers | | razor_channel | | razor_channel_product | | razor_ci_sessions | | razor_clientdata | | razor_clientusinglog | | razor_config | | razor_dim_activity | | razor_dim_date | | razor_dim_devicebrand | | razor_dim_devicelanguage | | razor_dim_deviceos | | razor_dim_deviceresolution | | razor_dim_devicesupplier | | razor_dim_errortitle | | razor_dim_event | | razor_dim_location | | razor_dim_network | | razor_dim_product | | razor_dim_segment_launch | | razor_dim_segment_usinglog | | razor_errorlog | | razor_event_defination | | razor_eventdata | | razor_fact_clientdata | | razor_fact_errorlog | | razor_fact_event | | razor_fact_launch_daily | | razor_fact_usinglog | | razor_fact_usinglog_daily | | razor_getui_product | | razor_hour24 | | razor_log | | razor_login_attempts | | razor_markevent | | razor_mccmnc | | razor_networktype | | razor_platform | | razor_plugins | | razor_product | | razor_product_category | | razor_product_version | | razor_productfiles | | razor_reportlayout | | razor_sum_accesslevel | | razor_sum_accesspath | | razor_sum_basic_activeusers | | razor_sum_basic_byhour | | razor_sum_basic_channel | | razor_sum_basic_channel_activeusers | | razor_sum_basic_product | | razor_sum_basic_product_version | | razor_sum_reserveusers_daily | | razor_sum_reserveusers_monthly | | razor_sum_reserveusers_weekly | | razor_sum_usinglog_activity | | razor_tag_group | | razor_target | | razor_targetevent | | razor_user2product | | razor_user2role | | razor_user_autologin | | razor_user_permissions | | razor_user_profiles | | razor_user_resources | | razor_user_roles | | razor_userkeys | | razor_users | | razor_wifi_towers | +-------------------------------------+ 这些表| razor_dim_activity | | razor_dim_date | | razor_dim_devicebrand | | razor_dim_devicelanguage | | razor_dim_deviceos | | razor_dim_deviceresolution | | razor_dim_devicesupplier | | razor_dim_errortitle | | razor_dim_event | | razor_dim_location | | razor_dim_network | | razor_dim_product | | razor_dim_segment_launch | | razor_dim_segment_usinglog |好像丢失了，并且我在代码中发现调用select e.event_sk, e.eventidentifier, e.eventname, count(f.eventid) count from razor_dim_product p, razor_fact_event f, razor_dim_event e where p.product_id=2 and p.product_active=1 and p.channel_active=1 and p.version_active=1 and f.product_sk = p.product_sk and f.event_sk = e.event_sk group by e.event_sk,e.eventidentifier, e.eventname order by e.event_sk desc;语句时去获取事件列表失败 — Reply to this email directly or view it on GitHub.

[kansifang]

Cobub Razor-开源移动应用分析系统的安装指南 ：http://dev.cobub.com/zh/docs/cobub-razor/installation-guide/

ownerme

发件人： jiong056 发送时间： 2013-11-07 13:27 收件人： cobub/razor 抄送： kansifang 主题： Re: [razor] Cobub Razor 0.4 事件列表与新增用户数据不准 (#101) 我重新装了另一个Cobub Razor，发现有一下表： +-------------------------------------+ | Tables_in_test | +-------------------------------------+ | razor_alert | | razor_alertdetail | | razor_cell_towers | | razor_channel | | razor_channel_product | | razor_ci_sessions | | razor_clientdata | | razor_clientusinglog | | razor_config | | razor_dim_activity | | razor_dim_date | | razor_dim_devicebrand | | razor_dim_devicelanguage | | razor_dim_deviceos | | razor_dim_deviceresolution | | razor_dim_devicesupplier | | razor_dim_errortitle | | razor_dim_event | | razor_dim_location | | razor_dim_network | | razor_dim_product | | razor_dim_segment_launch | | razor_dim_segment_usinglog | | razor_errorlog | | razor_event_defination | | razor_eventdata | | razor_fact_clientdata | | razor_fact_errorlog | | razor_fact_event | | razor_fact_launch_daily | | razor_fact_usinglog | | razor_fact_usinglog_daily | | razor_getui_product | | razor_hour24 | | razor_log | | razor_login_attempts | | razor_markevent | | razor_mccmnc | | razor_networktype | | razor_platform | | razor_plugins | | razor_product | | razor_product_category | | razor_product_version | | razor_productfiles | | razor_reportlayout | | razor_sum_accesslevel | | razor_sum_accesspath | | razor_sum_basic_activeusers | | razor_sum_basic_byhour | | razor_sum_basic_channel | | razor_sum_basic_channel_activeusers | | razor_sum_basic_product | | razor_sum_basic_product_version | | razor_sum_reserveusers_daily | | razor_sum_reserveusers_monthly | | razor_sum_reserveusers_weekly | | razor_sum_usinglog_activity | | razor_tag_group | | razor_target | | razor_targetevent | | razor_user2product | | razor_user2role | | razor_user_autologin | | razor_user_permissions | | razor_user_profiles | | razor_user_resources | | razor_user_roles | | razor_userkeys | | razor_users | | razor_wifi_towers | +-------------------------------------+ 这些表| razor_dim_activity | | razor_dim_date | | razor_dim_devicebrand | | razor_dim_devicelanguage | | razor_dim_deviceos | | razor_dim_deviceresolution | | razor_dim_devicesupplier | | razor_dim_errortitle | | razor_dim_event | | razor_dim_location | | razor_dim_network | | razor_dim_product | | razor_dim_segment_launch | | razor_dim_segment_usinglog |好像丢失了，并且我在代码中发现调用select e.event_sk, e.eventidentifier, e.eventname, count(f.eventid) count from razor_dim_product p, razor_fact_event f, razor_dim_event e where p.product_id=2 and p.product_active=1 and p.channel_active=1 and p.version_active=1 and f.product_sk = p.product_sk and f.event_sk = e.event_sk group by e.event_sk,e.eventidentifier, e.eventname order by e.event_sk desc;语句时去获取事件列表失败 — Reply to this email directly or view it on GitHub.

[jiong056]

嗯，确认了一下，第一次搭得时候是用不同的数据库，第二次是用同一个数据库，那为什么第一次搭得razor 事件列表和新增用户数据会不准呢

[kansifang]

没有的那些表是在另外一个数据库（Cobub Razor数据库仓库所在在数据库）里面

ownerme

发件人： jiong056 发送时间： 2013-11-07 14:52 收件人： cobub/razor 抄送： kansifang 主题： Re: [razor] Cobub Razor 0.4 事件列表与新增用户数据不准 (#101) 嗯，确认了一下，第一次搭得时候是用不同的数据库，第二次是用同一个数据库，那为什么第一次搭得razor 事件列表和新增用户数据会不准呢 — Reply to this email directly or view it on GitHub.