Announcement

Collapse
No announcement yet.

Error importing application

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Error importing application

    I have to import my application but a message appears at the end sc_tbcmp.Campo may not be NULL and no matter what help is very important

  • #2
    Re: Error importing application

    Hello,

    Is this a V5 or V6 application? Could you try to export and import it again?

    regards,
    Bernhard Bernsmann

    Comment


    • #3
      Re: Error importing application

      Scriptcase version 6....I am also getting this error message.

      HERE IS THE ERROR:
      INSERT INTO sc_tbcmp (Cod_Prj, Versao, Cod_Apl, Seq, Login, Html_Tipo, Tipo_Dado, Tipo_Dado_Filtro, Tipo_Sql, Label, Label_Filtro, Usar_Label_Grid, Entra_Edit, Entra_Update, Entra_Sort, EntraDetalhe, EntraDetalheOrd, Def_Complemento, Def_Complemento_Cons, Def_Complemento_Pesq, Texto_Xml, Attr1, Attr2, Attr3, Attr4) VALUES ('CottonERP', 1, 'grid_historyworkorder', 10, 'admin', 'TEXT', 'TEXTO', 'TEXTO', 'VARCHAR', 'Wos Work Order Id', 'Wos Work Order Id', 'S', 'S', 'S', 'N', 'S', 10, 'a:0:{}', 'a:0:{}', 'a:0:{}', 'a:10:{s:6:"letras";s:1:"N";s:7:"numeros";s:1:"N"; s:10:"acentuacao";s:1:"N";s:7:"cedilha";s:1:"N";s: 6:"espaco";s:1:"N";s:5:"ponto";s:1:"N";s:7:"virgul a";s:1:"N";s:5:"todos";s:1:"S";s:4:"mais";s:0:"";s :5:"menos";s:0:"";}', 'a:235:{s:12:"autoinc_nome";s:0:"";s:16:"banco_val _forcar";s:1:"N";s:14:"banco_val_tipo";s:0:"";s:15 :"banco_val_valor";s:0:"";s:16:"autoinc_nome_upd"; s:0:"";s:20:"banco_val_forcar_upd";s:1:"N";s:18:"b anco_val_tipo_upd";s:0:"";s:19:"banco_val_valor_up d";s:0:"";s:15:"valida_condicao";s:0:"";s:12:"vali da_valor";i:0;s:15:"valida_mensagem";s:0:"";s:11:" label_texto";s:0:"";s:14:"var_glob_grava";s:1:"N"; s:13:"var_glob_nome";s:0:"";s:12:"campo_padrao";s: 0:"";s:15:"valida_redirect";s:0:"";s:14:"campo_exe c_ord";i:0;s:9:"jump_menu";s:0:"";s:13:"erro_mensa gem";s:0:"";s:12:"eof_msg_erro";s:0:"";s:15:"eof_v al_default";s:0:"";s:16:"liga_mostra_edit";s:1:"S" ;s:15:"acaosql_comando";s:0:"";s:15:"jump_menu_rad io";s:1:"N";s:11:"exec_submit";s:4:"SSNN";s:12:"fi eld_filter";s:1:"N";s:13:"form_val_tipo";s:0:"";s: 14:"image_html_img";s:0:"";s:21:"image_html_img_bo rder";s:1:"0";s:20:"image_html_img_width";s:1:"0"; s:21:"image_html_img_height";s:1:"0";s:12:"repete_ valor";s:1:"S";s:13:"conteudo_html";s:1:"N";s:13:" lookup_tabela";s:1:"N";s:13:"lookup_objeto";s:0:"" ;s:21:"lookup_exibe_lab_edit";s:1:"N";s:14:"lookup _tamanho";i:1;s:15:"lookup_tab_nome";s:0:"";s:16:" lookup_cmp_lista";s:0:"";s:15:"label_recarrega";s: 1:"N";s:12:"label_ancora";s:0:"";s:9:"help_tipo";i :3;s:8:"path_sub";s:0:"";s:9:"doc_icone";s:1:"N";s :14:"path_sub_criar";s:1:"N";s:8:"desc_usa";s:1:"N ";s:10:"desc_valid";s:1:"N";s:8:"desc_sql";s:0:""; s:9:"desc_face";s:0:"";s:9:"desc_size";s:0:"";s:10 :"desc_color";s:0:"";s:9:"desc_tipo";s:1:"A";s:11: "exec_inicio";s:1:"N";s:17:"fil_entre_val_pos";s:1 :"A";s:17:"fil_entre_val_txt";s:0:"";s:12:"graf_gr oupby";s:1:"N";s:11:"graf_funcao";s:0:"";s:12:"gra f_percent";s:1:"N";s:13:"graf_user_def";s:1:"S";s: 13:"lookup_mostra";s:1:"N";s:12:"lookup_delim";s:3 :" - ";s:13:"date_calendar";s:1:"N";s:17:"calendar_max_ year";s:2:"10";s:10:"jump_omite";s:1:"N";s:14:"lig a_url_saida";s:0:"";s:21:"liga_cons_mod_inicial";s :0:"";s:18:"liga_cons_qtd_rows";s:0:"";s:18:"liga_ cons_qtd_cols";s:0:"";s:19:"liga_cons_paginacao";s :0:"";s:16:"liga_cons_header";s:0:"";s:17:"liga_co ns_btn_nav";s:0:"";s:10:"css_celula";s:0:"";s:8:"c ss_form";s:0:"";s:17:"css_titulo_filtro";s:0:"";s: 16:"css_campo_filtro";s:0:"";s:17:"css_objeto_filt ro";s:0:"";s:15:"css_titulo_form";s:0:"";s:14:"css _campo_form";s:0:"";s:15:"css_objeto_form";s:0:""; s:11:"label_botao";s:1:"N";s:12:"cor_negativo";s:0 :"";s:8:"tit_bold";s:1:"S";s:9:"tot_title";s:0:""; s:8:"desc_eof";s:0:"";s:12:"date_display";s:1:"S"; s:18:"date_display_combo";s:1:"N";s:13:"lookup_fil tro";s:1:"N";s:13:"lookup_limite";i:100;s:13:"look up_inicio";s:1:"L";s:13:"lookup_campos";s:0:"";s:1 2:"cep_onchange";s:1:"N";s:10:"liga_forca";s:1:"N" ;s:11:"liga_insert";s:1:"R";s:12:"liga_tamanho";i: 700;s:14:"liga_cabecalho";s:1:"N";s:12:"liga_posic ao";s:1:"B";s:12:"liga_largura";i:350;s:6:"hidden" ;s:1:"N";s:11:"campo_label";s:1:"N";s:17:"critica_ sc_submit";s:1:"S";s:11:"image_cache";i:0;s:10:"im age_link";s:1:"N";s:11:"image_popup";s:1:"S";s:11: "doc_db_size";s:0:"";s:15:"onchange_submit";s:1:"N ";s:21:"show_filter_condition";s:1:"S";s:23:"quebr a_visu_label_fonte";s:0:"";s:22:"quebra_visu_label _size";s:0:"";s:23:"quebra_visu_label_color";s:0:" ";s:25:"quebra_visu_label_bgcolor";s:0:"";s:25:"qu ebra_visu_label_negrito";s:0:"";s:23:"quebra_visu_ campo_fonte";s:0:"";s:22:"quebra_visu_campo_size"; s:0:"";s:23:"quebra_visu_campo_color";s:0:"";s:25: "quebra_visu_campo_bgcolor";s:0:"";s:25:"quebra_vi su_campo_negrito";s:0:"";s:20:"tot_linha_visu_font e";s:0:"";s:19:"tot_linha_visu_size";s:0:"";s:20:" tot_linha_visu_color";s:0:"";s:22:"tot_linha_visu_ bgcolor";s:0:"";s:22:"tot_linha_visu_negrito";s:0: "";s:26:"tot_linha_visu_campo_fonte";s:0:"";s:25:" tot_linha_visu_campo_size";s:0:"";s:26:"tot_linha_ visu_campo_color";s:0:"";s:28:"tot_linha_visu_camp o_bgcolor";s:0:"";s:28:"tot_linha_visu_campo_negri to";s:0:"";s:26:"tot_geral_linha_visu_fonte";s:0:" ";s:25:"tot_geral_linha_visu_size";s:0:"";s:26:"to t_geral_linha_visu_color";s:0:"";s:28:"tot_geral_l inha_visu_bgcolor";s:0:"";s:28:"tot_geral_linha_vi su_negrito";s:0:"";s:25:"formato_data_outro_filtro ";s:0:"";s:13:"decimais_pesq";i:0;s:16:"simbolo_ag r_pesq";s:1:".";s:16:"simbolo_dec_pesq";s:1:",";s: 15:"aceita_neg_pesq";s:1:"N";s:9:"usar_calc";s:1:" N";s:19:"quebra_ini_treeview";s:1:"A";s:22:"lkpdef _exib_label_desc";s:1:"N";s:11:"subcons_pos";s:1:" M";s:16:"subcons_treeview";s:1:"N";s:11:"subcons_p df";s:1:"S";s:14:"quebra_orderby";s:0:"";s:17:"tab _lig_check_all";s:1:"N";s:9:"pdf_pos_x";s:0:"";s:9 :"pdf_pos_y";s:0:"";s:14:"pdf_inc_height";s:2:"20" ;s:15:"texto_underline";s:1:"N";s:13:"subselect_se q";i:0;s:16:"subselect_fields";s:0:"";s:16:"fil_da te_esp_opt";i:1;s:17:"fil_date_esp_cond";s:146:"bi _todo_periodo_@NM@_bi_hoje_@NM@_bi_ontem_@NM@_bi_u lt_7_dias_@NM@_bi_sem_pas_seg_dom_@NM@_bi_ult_sem_ com_seg_sex_@NM@_bi_este_mes_@NM@_bi_ult_mes";s:19 :"editor_html_toolbar";s:247:"bold_BT_italic_BT_un derline_BT_strikethrough_BT_justifyleft_BT_justify center_BT_justifyright_BT_justifyfull_BT_bullist_B T_numlist_BT_undo_BT_redo_BT_fontselect_BT_fontsiz eselect_BT_forecolor_BAR_tablecontrols_BT_link_BT_ unlink_BT_emotions_BT_image";s:19:"editor_html_qtd _bar";i:2;s:19:"editor_html_pos_bar";s:3:"top";s:2 1:"editor_html_align_bar";s:6:"center";s:18:"edito r_html_status";s:0:"";s:12:"graf_tp_graf";s:0:"";s :14:"graf_cor_fundo";s:0:"";s:15:"graf_cor_margem" ;s:0:"";s:15:"graf_cor_labels";s:0:"";s:13:"graf_c or_vals";s:0:"";s:14:"graf_preen_esp";s:1:"N";s:14 :"graf_show_vals";s:1:"N";s:16:"graf_show_marcas"; s:1:"N";s:14:"graf_tp_marcas";s:1:"Q";s:11:"graf_a ngulo";i:45;s:18:"editor_html_height";i:0;s:13:"co nn_lkp_cons";s:0:"";s:20:"usar_config_regional";s: 1:"S";s:16:"simbolo_negativo";s:1:"-";s:22:"formato_moeda_positivo";s:1:"3";s:22:"form ato_moeda_negativo";s:0:"";s:20:"formato_num_negat ivo";s:0:"";s:8:"sep_data";s:1:"/";s:8:"sep_hora";s:1:":";s:22:"format_data_config_ reg";s:0:"";s:13:"reload_locale";s:1:"N";s:18:"sho w_img_url_email";s:1:"S";s:16:"qtd_decimais_sec";i :0;s:13:"prim_dia_sema";s:2:"SU";s:14:"bar_code_pa ram";s:0:"";s:17:"youtube_exib_mode";s:5:"modal";s :18:"youtube_exib_width";i:0;s:19:"youtube_exib_he ight";i:0;s:17:"youtube_link_text";s:0:"";s:16:"yo utube_opt_link";s:3:"txt";s:18:"googlemaps_tp_orig ";s:7:"geocode";s:14:"googlemaps_url";s:0:"";s:19: "googlemaps_latitude";s:0:"";s:20:"googlemaps_long itude";s:0:"";s:18:"googlemaps_geocode";s:0:"";s:2 0:"googlemaps_exib_mode";s:5:"modal";s:16:"googlem aps_width";i:0;s:17:"googlemaps_height";i:0;s:15:" googlemaps_zoom";i:14;s:18:"googlemaps_api_key";s: 0:"";s:20:"googlemaps_link_text";s:0:"";s:19:"goog lemaps_opt_link";s:3:"txt";s:20:"googlemaps_mark_d esc";s:0:"";s:26:"group_usar_config_regional";s:1: "S";s:28:"group_format_data_config_reg";s:0:"";s:2 6:"group_mascara_grid_detalhe";s:0:"";s:24:"group_ formato_data_outro";s:0:"";s:17:"label_watermarked ";s:0:"";s:16:"show_image_valid";s:1:"N";s:31:"use _zero_with_format_when_digit";s:1:"N";s:15:"use_gr oup_digit";s:1:"S";s:17:"use_simbolo_moeda";s:1:"N ";s:27:"usar_config_regional_filter";s:1:"S";s:29: "format_data_config_reg_filter";s:0:"";s:17:"combi ne_date_time";s:1:"S";s:18:"validate_with_mask";s: 1:"N";s:13:"disable_field";s:1:"N";s:15:"date_comb o_year";s:1:"N";s:19:"date_combo_year_ini";s:4:"19 01";s:19:"date_combo_year_end";s:2:"10";s:21:"simb olo_moeda_usuario";s:1:"$";s:16:"show_number_week" ;s:1:"S";s:22:"show_additional_months";s:0:"";s:21 :"show_combo_year_month";s:1:"S";s:19:"option_new_ calendar";s:1:"S";s:15:"option_new_calc";s:1:"S";s :19:"option_new_cor_html";s:1:"S";s:16:"option_cal c_type";s:1:"P";s:15:"checked_all_col";s:1:"S";s:9 :"qr_margin";i:1;s:7:"qr_size";i:2;s:14:"qr_error_ level";i:0;s:8:"spin_use";s:1:"N";s:9:"spin_step"; i:1;s:12:"spin_pg_step";i:5;s:22:"use_dd_checkbox_ jquery";s:1:"N";s:14:"use_timepicker";s:1:"N";s:18 :"dd_checkbox_height";s:3:"150";}', 'a:1:{s:6:"formjs";a:0:{}}', '', 'a:108:{s:11:"val_inicial";s:0:"";s:12:"html_largu ra";i:14;s:11:"html_linhas";i:0;s:9:"pre_obrig";s: 1:"N";s:10:"tam_minimo";i:0;s:10:"tam_maximo";i:14 ;s:10:"val_minimo";i:0;s:10:"val_maximo";i:0;s:8:" decimais";i:0;s:10:"aceita_neg";s:1:"N";s:12:"form ato_data";s:4:"NADA";s:11:"simbolo_agr";s:1:",";s: 11:"simbolo_dec";s:1:".";s:16:"texto_transforma";s :4:"NADA";s:9:"read_only";s:1:"N";s:11:"soma_colun a";s:1:"N";s:12:"grupo_coluna";s:1:"N";s:16:"grupo _coluna_ord";i:0;s:14:"chave_primaria";s:1:"N";s:1 9:"comando_select_edit";s:0:"";s:15:"descricao_hin ts";s:0:"";s:9:"char_tipo";s:0:"";s:14:"char_image _pos";s:0:"";s:14:"char_image_neg";s:0:"";s:11:"ch ar_altura";s:1:"0";s:12:"char_largura";s:1:"0";s:1 4:"char_icone_qtd";i:0;s:18:"mascaragriddetalhe";s :0:"";s:22:"select_search_checkbox";s:1:"N";s:21:" select_search_colunas";s:1:"1";s:11:"formata_neg"; s:1:"2";s:13:"formata_moeda";s:1:"N";s:14:"liga_ap licacao";s:0:"";s:11:"liga_campos";s:0:"";s:11:"lo okup_cons";s:1:"N";s:11:"lookup_pesq";s:1:"N";s:11 :"lookup_edit";s:1:"A";s:10:"data_combo";s:1:"N";s :18:"formato_data_outro";s:0:"";s:12:"busca_opcoes ";s:49:"eq,N;ii,N;qp,N;df,N;gt,N;ge,N;lt,N;le,N;bw ,N;in,N";s:16:"url_outra_pagina";s:1:"N";s:13:"moe da_simbolo";s:1:"$";s:13:"valor_extenso";s:1:"N";s :21:"valor_extenso_tamanho";s:1:"0";s:15:"bar_code _altura";s:1:"0";s:16:"bar_code_largura";s:1:"0";s :14:"bar_code_fonte";s:1:"0";s:13:"tipo_password"; s:1:"N";s:13:"imagem_altura";s:1:"0";s:14:"imagem_ largura";s:1:"0";s:11:"texto_fonte";s:0:"";s:13:"t exto_tamanho";s:0:"";s:9:"texto_cor";s:0:"";s:9:"c or_fundo";s:0:"";s:13:"texto_italico";s:1:"N";s:10 :"texto_bold";s:1:"N";s:17:"texto_alinhamento";s:1 :"1";s:13:"texto_formata";s:4:"NADA";s:12:"texto_n owrap";s:1:"S";s:12:"cons_largura";i:14;s:16:"sepa rador_string";s:1:";";s:11:"edit_altura";s:1:"0";s :14:"edit_multiplas";s:1:"N";s:9:"calculado";s:1:" N";s:13:"texto_colunas";s:1:"0";s:12:"mostra_zeros ";s:1:"S";s:14:"casas_decimais";i:0;s:11:"graf_vis ual";s:1:"0";s:14:"xml_formatacao";s:0:"";s:11:"da ta_minimo";s:10:"0000-00-00";s:11:"data_maximo";s:10:"0000-00-00";s:13:"graf_sumariza";s:1:"N";s:11:"graf_quebra ";s:1:"N";s:17:"lookup_cons_entra";s:1:"3";s:18:"t exto_valinhamento";s:1:"1";s:12:"imagem_fundo";s:0 :"";s:16:"img_outra_pagina";s:1:"S";s:11:"img_aspe cto";s:1:"S";s:12:"imagem_borda";s:1:"0";s:11:"cel l_height";s:1:"0";s:17:"data_minimo_opcao";s:1:"0" ;s:17:"data_maximo_opcao";s:1:"0";s:15:"data_minim o_exp";s:0:"";s:15:"data_maximo_exp";s:0:"";s:18:" titulo_alinhamento";s:1:"1";s:10:"graf2_tipo";s:1: "0";s:12:"graf2_altura";s:1:"0";s:13:"graf2_largur a";s:1:"0";s:12:"graf2_margem";s:1:"0";s:13:"graf2 _aspecto";s:1:"S";s:11:"graf2_label";s:1:"0";s:15: "lookup_original";s:1:"N";s:18:"lookup_delimitador ";s:3:" - ";s:15:"quebra_sumariza";s:1:"S";s:12:"quebra_coun t";s:1:"S";s:23:"titulo_alinhamento_vert";s:1:"2"; s:15:"busca_recarrega";s:1:"N";s:14:"liga_busca_ap l";s:0:"";s:14:"liga_busca_cmp";s:0:"";s:9:"qtd_by tes";s:1:"0";s:13:"quebra_pagina";s:1:"N";s:12:"qu ebra_exibe";s:1:"N";s:16:"char_col_largura";s:1:"0 ";s:12:"completa_esq";s:0:"";s:17:"campo_relaciona do";s:1:"0";s:16:"mascara_consulta";s:0:"";s:13:"t amanho_banco";i:14;s:14:"variavel_where";s:1:"N";} ')
      sc_tbcmp.Campo may not be NULL

      Screenshot attached.
      Kris
      Attached Files

      Comment


      • #4
        Re: Error importing application

        Hello Austin,

        Is this problem happening on a specific application? Please contact us directly at our support so we can solve this issue as quickly as possible.

        regards,
        Bernhard Bernsmann

        Comment


        • #5
          Re: Error importing application

          I'm facing same problem when restoring backup data or importing application or project.
          This thread created on 4th June, I wonder if scriptcase's dev team has already found the solution yet?
          Attached Files

          Comment


          • #6
            Re: Error importing application

            Hello Mellz,

            Please contact us directly at our support so we can solve this issue as quickly as possible.

            regards,
            Bernhard Bernsmann

            Comment


            • #7
              I am getting a similar issue in Version 7, but cannot figure out how to contact support (it says I do not have ticket support or chat support). Is this an issue that cannot be resolved unless you pay for support?


              INSERT INTO sc_tbcmp (Cod_Prj, Versao, Cod_Apl, Seq, Login, Html_Tipo, Usar_Label_Grid, Entra_Edit, Entra_Update, Entra_Sort, EntraDetalhe, EntraDetalheOrd, Def_Complemento, Def_Complemento_Cons, Def_Complemento_Pesq, Texto_Xml, Attr1, Attr2, Attr3, Attr4) VALUES ('Gainco_Web_Reporting_2', 3, 'grid_vw_gainco_products_report_federated_single', 360, 'admin', 'TEXT', 'S', 'S', 'S', 'N', 'S', 360, 'a:0:{}', 'a:0:{}', 'a:0:{}', 'a:0:{}', 'a:273:
              ...
              {}s:16:"char_col_largura";s:1:"0";s:12:"completa_e sq";s:0:"";s:17:"campo_relacionado";s:1:"0";s:16:" mascara_consulta";s:0:"";s:13:"tamanho_banco";i:0; s:14:"variavel_where";s:1:"N";s:20:"fld_group_org_ campos";a:0:{}s:14:"fld_group_cols";a:0:{}s:21:"fl d_group_exibe_label";a:0:{}s:23:"fld_group_linha_s um_res";a:0:{}s:23:"fld_group_msg_linha_sum";a:0:{ }s:30:"fld_group_graf_group_new_title";a:0:{}s:35: "fld_group_graf_group_title_show_val";a:0:{}s:28:" fld_group_quebra_pag_pdf_res";a:0:{}s:30:"fld_grou p_quebra_pag_html_cons";a:0:{}s:29:"fld_group_queb ra_pag_html_res";a:0:{}s:16:"fld_group_campos";a:0 :{}s:20:"show_upload_progress";s:1:"S";s:16:"show_ upload_zone";s:1:"S";s:11:"mu_qtd_cols";i:1;s:13:" mu_pos_delete";s:6:"beside";s:16:"mu_pos_on_upload ";s:5:"above";s:14:"mu_show_status";s:7:"img_txt"; s:8:"mu_table";s:0:"";s:9:"mu_fields";a:0:{}s:14:" campo_url_link";s:1:"S";s:16:"campo_url_target";s: 6:"_blank";s:13:"graf2_aspecto";s:1:"S";}')
              sc_tbcmp.Campo may not be NULL

              Comment

              Working...
              X