Database Errors Interview Questions
Questions Answers Views Company eMail

AMD-00130: dimension #string: RDBMS dimension column data type not specified

1 2901

AMD-00131: dimension #string: RDBMS parent column data type not specified

1 2508

AMD-00132: dimension #string: RDBMS GID column data type not specified

1 2571

AMD-00133: measure #string: analytic workspace measure name not specified

1 2393

AMD-00134: measure #string: RDBMS measure column name not specified

1 2486

AMD-00135: measure #string: RDBMS measure column data type not specified

1 2935

AMD-00136: Generation of SQL script "string" failed

1 2681

AMD-00137: prefix "string" exceeds maximum permitted length of string characters

1 2607

AMD-00138: level names parameter not null or defaulted

1 2352

AMD-00139: level names parameter not valid

1 2598

AMD-00140: internal error: [string] [string] [string] [string] [string]

1 3354

AMD-00141: parameter string of "string" not valid starting around "string"

1 2460

AMD-00142: Analytic Workspace name "string" must be fully qualified with the Owner.

1 2750

AMD-00143: View name "string" must be fully qualified with the Owner.

1 2596

AMD-00144: Custom Measure "string" does not exist in Workspace "string"

1 2717


Un-Answered Questions { Database Errors }

How will you Handle Error in SQL SERVER 2008?

2122


NZE-28890: Entrust Login Failed

1608


IMP-00064: Definition of LOB was truncated by export

6140


NZE-28868: Peer certificate chain check failed.

2492


IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

2940


ORA-26032: index string.string loading aborted after string keys

1852


IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1414


I have written the code as below. here problem is that dt remain null. how to solve thst please tell me. public partial class Form1 : Form { private DataTable DTable; private DataRow drow; public Form1() { InitializeComponent(); } private OleDbConnection getConnection() { OleDbConnection con=new OleDbConnection (@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\My Documents\Visual Studio 2008\Projects\winApp for Student\winApp for Student\App_Data\SchooMgnSystem.mdb;Persist Security Info=True"); return con; } private void button1_Click(object sender, EventArgs e) { InsertData(); } private void InsertData() { if (DTable==null) { DTable = new DataTable(); DTable.Columns.Add("StudID", typeof(string)); DTable.Columns.Add("StudName", typeof (string)); DTable.Columns.Add("Address", typeof(string)); drow = DTable.NewRow(); drow[0] = txtStudID.Text; drow[1] = txtSTudName.Text; drow[2] = txtAddress.Text; DTable.Rows.Add(drow); grdStudent.DataSource = DTable; } else { drow = DTable.NewRow(); drow[0] = txtStudID.Text; drow[1] = txtSTudName.Text; drow[2] = txtAddress.Text; DTable.Rows.Add(drow); grdStudent.DataSource = DTable; } } private void button2_Click(object sender, EventArgs e) { string cmdstr; OleDbCommand cmd; OleDbConnection con = getConnection(); foreach (DataRow Drow in DTable.Rows) { cmdstr = "Insert into Student values('" + drow[0].ToString() + "','" + drow[1].ToString() + "','"+drow [2].ToString()+"')"; cmd = new OleDbCommand(cmdstr,con); try { con.Open(); cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.Close(); } } }

2424


write a database figure to implement the master detained relationship.

2664


ORA-26094: stream format error: input column overflow

2565


Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

2471


I entered the data in SQL toad version 9.0.1 in English and Arabic language but when i do the query i get the data in Arabic language with (??? question mark) ,please your support.

1324


ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2532


ORA-26084: direct path context already finished

1691


IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2508