Lookup Field --- I Need Help

Jan 11, 2010 at 8:57 PM

I need Help for this file Config.

I have List (Cursos)

Fields

-NombreCurso (Text)

-Cupos (Numeric)

-PreRequisito (Lookup -> Cursos -> NombreCurso

Is Possible create this Lookup???

Thanks.


<?xml version="1.0" encoding="utf-8" ?>
<Configuration>
  <ConnectionStrings Default="SLAM">
    <add Name="SLAM" ConnectionString="Database=CLSCL_WSS_SLAM09;Data Source=CLSCLDB02;User Id=UserID***;Password=*****" />
  </ConnectionStrings>

  <DataMapping DataSchema="SLAM">
    <!--LISTA DE CURSOS (List of Courses)-->
    <List Site="/Training/ge/" Name="Cursos" ActivationOrder="1">
      <Fields>
        <Field Name="NombreCurso" SqlType="varchar(255)" SPType="Text" Required="true"></Field> 
        <Field Name="Cupos" SqlType="varchar(255)" SPType="Text" Required="true" ></Field>
        <Field Name="PreRequisito" SPType="Lookup" AssociatedList="Cursos" SqlType="varchar(255)" AssociationName="RequisitoCurso" ></Field>
     </Fields>
    </List>
  </DataMapping>
</Configuration>
Developer
Jan 11, 2010 at 9:03 PM

I should work.  Are you getting an error?

Jan 11, 2010 at 9:59 PM
awellenstein wrote:

I should work.  Are you getting an error?

 In the Event Viewer i Have tree Errors

1-.

An unhandled exception occurred and the process was terminated.

Application ID: /LM/W3SVC/252140120/Root

Process ID: 892

Exception: System.Data.SqlClient.SqlException

Message: Invalid column name 'Cursos2ListItemID'.
Invalid column name 'Cursos2ListItemID'.

StackTrace: 
Server stack trace: 
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
   at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
   at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
   at System.Data.Linq.DataContext.ExecuteMethodCall(Object instance, MethodInfo methodInfo, Object[] parameters)
   at System.Data.Linq.DataContext.ExecuteCommand(String command, Object[] parameters)
   at AWS.SLAM.Data.SqlDataRepository.AddAssociationTableSynchronizationObjects(String tableSchema, String tableName, String firstTypeName, String secondTypeName)
   at AWS.SLAM.Activation.SqlDataSynchronizeTypeProcessor.Process(String sharepointSiteLocation, IDictionary`2 parameters)
   at AWS.SLAM.Administration.Synchronization.DoSynchronization(SPSite site)
   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

Exception rethrown at [0]: 
   at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)
   at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData)
   at AWS.SLAM.Administration.Synchronization.SynchronizationProcess.EndInvoke(IAsyncResult result)
   at AWS.SLAM.Administration.Synchronization.CallBackMethod(IAsyncResult ar)
   at System.Runtime.Remoting.Messaging.AsyncResult.SyncProcessMessage(IMessage msg)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)
   at System.Runtime.Remoting.Proxies.AgileAsyncWorkerItem.DoAsyncCall()
   at System.Runtime.Remoting.Proxies.AgileAsyncWorkerItem.ThreadPoolCallBack(Object o)
   at System.Threading._ThreadPoolWaitCallback.WaitCallback_Context(Object state)
   at System.Threading.ExecutionContext.runTryCode(Object userData)
   at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading._ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack)
   at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback(Object state)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

2-.
Event Type:	Error
Event Source:	Windows SharePoint Services 3 Error Reporting
Event Category:	None
Event ID:	5000
Date:		11/01/2010
Time:		6:51:04 PM
User:		N/A
Computer:	CLSCLAPT09
Description:
EventType ulsexception12, P1 w3wp.exe, P2 6.0.3790.3959, P3 45d6968e, P4 mscorlib, P5 2.0.0.0, P6 4889dc80, P7 16819, P8 163, P9 sqlexception, P10 8yr8.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

3-.
Event Type:	Error
Event Source:	.NET Runtime 2.0 Error Reporting
Event Category:	None
Event ID:	5000
Date:		11/01/2010
Time:		6:51:12 PM
User:		N/A
Computer:	CLSCLAPT09
Description:
EventType clr20r3, P1 w3wp.exe, P2 6.0.3790.3959, P3 45d6968e, P4 mscorlib, P5 2.0.0.0, P6 4889dc80, P7 41b3, P8 a3, P9 system.data.sqlclient.sql, P10 NIL.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Developer
Jan 11, 2010 at 10:18 PM

What about in the SLAM Diagnostics in the control panel?